PROBLEM
Querying for NULL values in a shapefile or coverage crashes ArcMap
Description
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" NULL
Using an operator (=, -, *, /) will prevent the crash, but no records will be returned.
Cause
This is a known issue.
Solution or Workaround
This problem is addressed in ArcGIS 8.1 Service Pack 1. See Related Information section to download this pack.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
- ArcMap 8 x
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback