I am doing a full text search on our database like this:
select Headline1, Headline2
from story
where
CONTAINS((Headline1,Headline2), '(FORMSOF(inflectional,best))',LANGUAGE 'English')
The problem is that rows that contain just the word "best" and no other variations are not retrieved. Rows that contain the word "good" or the word "bests" (notice the plural) are retrieved but not rows where just "best" is present.
If I change inflectional to thesaurus it works but that is not the functionality I want.
Any ideas?
Regards,
Mark