Hi guys,

When searching a full text catalog, I would like to allow inflections,
but I would also like to require that *all* words (or inflections
thereof) be included in a match.

FREETEXT() is inherently inflectional, but I do not know how to require
all tokens to be matched (because it discards the "AND" keyword).

CONTAINS(*, 'FORMSOF (INFLECTIONAL, <foo>)') does not seem to allow me
to specify the AND keyword either. Thus, it is functionally equivalent
to FREETEXT().

CONTAINS(*, 'foo AND bar') will find only matches with BOTH foo and
bar, but it will not count inflections of foo or bar.

I need to require ALL search terms (or inflections thereof) to match.
How do I do this in SQL Server?

Thank you very much!

Justin Keyes

Hmm... my question is answered mostly by the first post in this thread:
http://groups.google.com/group/microsoft.public.sqlserver.fulltext/browse_frm/thread/13d146f5e7ff8ddf/c59778124785a688?lnk=st&q=full+text+search+all+inflectional&rnum=2#c59778124785a688