8

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!

14

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
  • 2
    Likewise you can insert the NOT keyword to select ones that aren't null --- [FIELD_1] IS NOT NULL – Rayner Sep 10 '12 at 9:14
  • For some reson [FIELD] IS NULL does not work for me. There are clearly null values. – pbreach Mar 7 '16 at 0:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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