Searching within words - alternative?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

at_the_gonq@hotmail.com - 16 Feb 2007 20:42 GMT

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

Reply to this Message

Hilary Cotter - 17 Feb 2007 02:57 GMT

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.

Signature

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

> Hi guys,
>
[quoted text clipped - 9 lines]
>
> Nat

Reply to this Message