laptop and a wrench


In some scenarios, a definition query utilizing the 'SUBSTR' operator causes the following error, "An invalid SQL statement was used."

Last Published: December 1, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000092500
SubmittedNovember 25, 2015
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.1
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.


In some scenarios, the 'LIKE' operator serves as a workaround.

Steps to Reproduce

Bug ID: BUG-000092500


  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options