7098 The full text search condition has invalid operands specified for the NEAR operator

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)"