laptop and a wrench

Bug

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.

Workaround

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

Steps to Reproduce

Bug ID: BUG-000092500

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options