sql server full text search: Searching within words - alternative? -- sql server full text search

Searching within words - alternative?

at_the_gonq NO[at]SPAM hotmail.com
2/16/2007 12:42:32 PM

sql server full text search: Hi guys,

I have been writing a search engine that uses FTI, and have read that
you cannot use leading wildcards in your search clause (i.e. "*ome"
would not return home, but "hom*" would return home).

Just wondering if there is a solution to this problem while still
using CONTAINSTABLE & FTI? Or if I am going to have to go a different
route.

Thanks in advance!

Nat

Re: Searching within words - alternative?

Hilary Cotter
2/16/2007 9:57:32 PM

You can achieve some of what you are looking for by using replacements or
expansions in the thesaurus, but I think you should look at other options.

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

[quoted text, click to view]