1 OR numb IS NULL."/>
laptop and a wrench

Bug

Features with null values are ignored or not displayed when using the '<>' (not equal) operator in ArcMap.

Last Published: April 4, 2018 ArcGIS for Desktop
Bug ID Number BUG-000104895
SubmittedMay 3, 2017
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.5
StatusKnown Limit

Additional Information

I tested your case against the numeric "numb" field and a calculated text field "testnumb" and neither returns the null record. Detailed documentation on this can be found here: https://technet.microsoft.com/en-us/library/ms191270(v=sql.105).aspx. Essentially, NULL is not the same as blank, empty, or zero. It is an "unknown". Because it is of "unknown" value, our definition queries and selections will not return the value. To return the selection you desire, the correct query is: SELECT * FROM test1 WHERE numb <>1 OR numb IS NULL.

Steps to Reproduce

Bug ID: BUG-000104895

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