Re: how to make fuzzy search on ntext field

No, you could use full-text search and make it fuzzy by using the thesaurus
option. For example if you want to search on center and have it also return
hits to centre you would make centre and expansion of center in your
thesaurus file.

--
Hilary Cotter
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

"Ray" <Ray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:980DA353-8AD4-438E-9B03-9B020BECBD04@xxxxxxxxxxxxxxxx
Since difference and soundex functions can't be used with ntext.
How can i make fuzzy search to a fully indexed text database field that
has
ntext as data type ?

any special tricks ? or do i have to change it to nvarchar to make it work
?


.

Loading