"Krip" <amk@kynetix.com> wrote in message
news:9E599183-45E3-4CA8-8628-540038B91EB6@microsoft.com...
> We're using SQL Server 2005 service pack 1. It was my understanding that
> FreeTextTable automatically includes inflectional forms. We're not able
> to get any inflectional forms of words during the search (even if we use
> Contains with the special syntax). Are we missing something in the server
> configuration? Or is there a bug somewhere?
>
> Thanks,
> Krip
>

"Krip" <amk@kynetix.com> wrote in message
news:3424FB65-92CF-40BA-B08E-436298FABB96@microsoft.com...
> Hilary,
>
> Nope, not wrapping with double quotes. Here's the clause:
>
> INNER JOIN FreeTextTable(myTable, myField, 'tests') as FTT
>
> I have 'test' in the data but 'tests' doesn't find it. That's just one
> example (fox works but not foxes; landed works but not landing).
>
> The following doesn't work either:
>
> SELECT *
> FROM myTable
> WHERE CONTAINS(*, 'FORMSOF (INFLECTIONAL, foxes)')
>
> Also, I've now installed SP2 and rebuilt the catalag - same issue.
>
> Is there some place to enable inflectional forms? Or is there a
> dictionary to populate?
>
> Thanks,
> Krip
>
>
>