Talk:SQL Server Full Text Search

From Wikipedia, the free encyclopedia

what if you want to search with AND logic using the FORMSOF(inflectional,...) methodology.

if my search phrase is "sport Award" I can easily do an OR search using the following in my where clause: CONTAINS(Colname,'formsof(INFLECTIONAL,sport,award). but the and is far more tricky....

does anyone know how to do this without having multiple Contains statements (which greatly increases overhead)?

I know that I can use AND in a straight contains like so: CONTANS(column, '"sport" AND "award"') but this does not allow me to explore inflectional variations on the words...

nesting multiple FORMSOF's doesn't seem to work either like so: contains(column,'"formsof(inflectional,sport)"' AND 'formsof(inflectional,award)"')

anyone else found how to do this?

LIKE THIS:

contains(column,'formsof(inflectional,sport) AND formsof(inflectional,award)'), all in one single quoted string, so close, and yet so far.