Advantage Error Guide
Problem: The full text search condition specified in a CONTAINS() function has invalid operands specified for the NEAR operator. The NEAR operator cannot have a NOT condition as an operand..
Solution: Verify the operands to the NEAR operator do not contain NOT conditions. For example, the following two search conditions are not valid:
"(medical and not doctor) near hospital"
"landscaping near () (not shrubbery)"
The following two are valid:
"medical near hospital and not (doctor near hospital)"
"not (landscaping near shrubbery)"