Groups | Blog | Home
all groups > sql server full text search > november 2003 >

sql server full text search : Is a fulltext search for *whatever possible?



Hilary Cotter
11/14/2003 5:15:48 AM
This feature does not ship with current versions of SQL
FTS. It may ship in a future version although I have kno
knowledge of what MS has planned. IBM's full text search
solution does support this, but it is expensive.

You basically have to do some thesaurus like functionality
to expand your search to words that have those endings.

[quoted text, click to view]
Matthias HALDIMANN
11/14/2003 1:23:57 PM
Using CONTAINS, we can search for "never*" and we will find "nevertheless".
However, I would like to do the inverse: "*less" should also find
"nevertheless". Strangely, I can't find that in the doc and it does not seem
to work.

Am I getting something wrong? Or is this really not possible?

Thanks a lot for your hints,
Matthias Haldimann

PS: This "*whatever" search may not look THAT useful in English, but it is
very important for searches within German nouns.

AddThis Social Bookmark Button