PROBLEM
Using the following SQL statement in the Select By Attribute dialog to query blank records in a shapefile or coverage will cause ArcMap to crash:"Fieldname" NULLUsing an operator (=, -, *, /) will prevent the crash, but no records will be returned.
This is a known issue.
For all versions of ArcGIS, use two single quotes to query for blank values in a string field and a zero to query for blank records in a number field. For example:
Code:
"StringField" = ''
Code:
"NumberField" = 0
Note:
Shapefile and Coverage attribute tables are not capable of storing NULL values in number and string fields, only NULL dates are permitted. ArcGIS does not recognize NULL date values.
Article ID:000003696
Get help from ArcGIS experts
Download the Esri Support App