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