The expression is not valid.
When building an expression using the Query Builder, use the Verify button to confirm that the expression is valid. If Verify returns an error or cannot be used, recheck the expression and try again. Structured Query Language (SQL) is a standard computer language for accessing and managing databases. SQL expressions are used in many parts of ArcGIS and its extensions to define a subset of data on which to perform some operation.
For help in building a successful expression, see Write a query in the query builder.