Syntax error near ‘of’ in the full-text search condition ‘control of’

Enclose the keywords in double quotes if you want to search exactly for control of

SET @Keywords=""control of""

If you want to search for control and of, use the following:

SET @Keywords="control AND of"

But server may consider of as a garbage or stop word, so in this case use the following:

SET @Keywords="control AND "of""

Leave a Comment

tech