8

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

What is the valid SQL statement that could get me all the null values?

1 Answer 1

15

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
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.