SQL 2005 - Full text catalog - Search with Freetext (with partial search ) doesn't populate values
Posted on 2013-06-04
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