Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.
Last Published: October 9, 2017ArcSDE/Enterprise Geodatabase
Bug ID Number
February 17, 2015
January 28, 2021
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
This is expected behavior. The LIKE operator is an operator for character strings. If it is used against a numeric field, the data must be converted to a string. Some databases support implicit conversion from numeric to text, some do not. If the data is pulled from a single database, the query validation can be pushed down to the database. In the case of data being pulled from multiple sources, the validation cannot be pushed to the database and client rules are used instead, and character string operators such as LIKE are flagged as invalid by client-side validation.
To query character matches like this the data should be stored as text, or the query should be written using >= and <= operators.