7097 The full text search condition is not valid

Advantage Error Guide

Problem: The full text search condition specified in a CONTAINS() function has extraneous information at the end of the condition, or it does not have balanced parentheses.

Solution: Verify that the parentheses and logical operators are balanced. For example, the search condition "medical and doctor)" is not valid because it does not have an opening parenthesis.