views:

110

answers:

0

Quick FTS question.

I have a table(Person) with 10 varchar columns (fname, surname, hair colour, etc), I've create a FT Index on it however queries using containstable return nothing for 'AND' queries e.g. FROM CONTAINSTABLE(tablename, *, 'john AND doe', 20) or CONTAINSTABLE(tablename, *, '(FORMSOF(INFLECTIONAL, john) AND FORMSOF(INFLECTIONAL, doe)), 20).

Both terms exist in the index if I use dm_fts_index_keywords.

Any thoughts? Appreciate any help anyone can offer.

Slán

Gar