laptop and a wrench

Bug

Select By Attributes fails to return records when the WHERE clause includes a Text data type field and an addition field of any data type.

Last Published: February 1, 2017 ArcGIS for Desktop
Bug ID Number BUG-000101865
SubmittedJanuary 4, 2017
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.4.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Workaround

Include a function to make the Text field values all uppercase. For example, use Upper() for Oracle.

Steps to Reproduce

Bug ID: BUG-000101865

Software:

  • ArcGIS for Desktop

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