laptop and a wrench

Bug

Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.

Last Published: October 9, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085345
SubmittedFebruary 17, 2015
Last ModifiedJanuary 28, 2021
SeverityMedium
Applies toArcSDE/Enterprise Geodatabase
Version found10.1
StatusWill Not Be Addressed

Additional Information

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.

Steps to Reproduce

Bug ID: BUG-000085345

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback