MYSQLuser
asked on
SQL 2005 - Full text catalog - Search with Freetext (with partial search ) doesn't populate values
Hi
I am using FTcatalog for SQL 2005.
I am trying to get the value for the column Description whose datatype is ntext, null.
when I do a serach with complete descrition like 'tester' -- getsthe data.
But when I do it with "test" -- Nothing displays.
SELECT * FROM Notes WHERE FREETEXT (Description,'hydrogel') - Works fine
SELECT * FROM Notes WHERE FREETEXT (Description,'hydro') -- Nothing displays
I would like to know if there is any restriction for the datatype ntext withing frreetext for getting partila search phrases...
Let me know
I am using FTcatalog for SQL 2005.
I am trying to get the value for the column Description whose datatype is ntext, null.
when I do a serach with complete descrition like 'tester' -- getsthe data.
But when I do it with "test" -- Nothing displays.
SELECT * FROM Notes WHERE FREETEXT (Description,'hydrogel') - Works fine
SELECT * FROM Notes WHERE FREETEXT (Description,'hydro') -- Nothing displays
I would like to know if there is any restriction for the datatype ntext withing frreetext for getting partila search phrases...
Let me know
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FREETEXT does not work with partial matches. Use CONTAINS instead:
http://technet.microsoft.com/en-us/library/ms142492%28SQL.90%29.aspx