How to force FTS on fractions?

When I made the jump to SQL 2005 from SQL 2000, the following query stopped
working. ie no result set unless I remove the fraction 1/4.
(Removing the fraction 1/4 works, but then returns many many rows)
SELECT * FROM MAKT
WHERE CONTAINS(MAKTX,'"valve" AND "SS" AND "needle" AND "1/4"')
With my old database on SQL2000, the same query returns:
IDMATNRMAKTX
65129502030710Valve, needle, 1/4", body material ss
77651902030890Valve, needle, 1/4", body material ss
59756502030900Valve, needle, 1/4", body material ss
77651602030860Valve, needle, 1/4", body material ss
60563702030990Valve, needle, 1/4", body material ss
***
The SQL 2000 database was copied to a new WIN2003 x64 server with SQL 2005
pro x64. Other than OS and SQL version, the databases are identical. Both
databases have FTS on the table in question. SQL 2005 just won't return a
result set on fractions. Is there a switch or registry hack? Can I go back to
SQL2000 FTS engine?
This works for me, what language are you querying and indexing in?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dennis4j" <Dennis4j@.discussions.microsoft.com> wrote in message
news:9F4FDA26-FAA1-468E-930C-9DD4FC9512C8@.microsoft.com...
> When I made the jump to SQL 2005 from SQL 2000, the following query
> stopped
> working. ie no result set unless I remove the fraction 1/4.
> (Removing the fraction 1/4 works, but then returns many many rows)
> SELECT * FROM MAKT
> WHERE CONTAINS(MAKTX,'"valve" AND "SS" AND "needle" AND "1/4"')
> With my old database on SQL2000, the same query returns:
> ID MATNR MAKTX
> 651295 02030710 Valve, needle, 1/4", body material ss
> 776519 02030890 Valve, needle, 1/4", body material ss
> 597565 02030900 Valve, needle, 1/4", body material ss
> 776516 02030860 Valve, needle, 1/4", body material ss
> 605637 02030990 Valve, needle, 1/4", body material ss
> ***
> The SQL 2000 database was copied to a new WIN2003 x64 server with SQL 2005
> pro x64. Other than OS and SQL version, the databases are identical. Both
> databases have FTS on the table in question. SQL 2005 just won't return a
> result set on fractions. Is there a switch or registry hack? Can I go back
> to
> SQL2000 FTS engine?
>