[GIS] Select all “NULL” values in the attribute table

arcgis-10.0attribute-tableselectselect-by-attribute

I have a quite simple syntax question.

I want to select ALL my null values in an attribute table of a feature class, not just the values in a single field.

So the question would be: what is the valid sql statement that could get me all the null values?

Thank you!

Best Answer

Without knowing what your data looks like, the general syntax you need to insert into the select by attributes window is:

[FIELD_1] IS NULL OR [FIELD_2] IS NULL OR [FIELD_3] IS NULL

and so on for as many fields as you have to work with. For reference the full query would be:

SELECT * FROM [TABLE_NAME] WHERE [FIELD_1] IS NULL OR [FIELD_2] IS NULL OR [FIELD_3] IS NULL
Related Question