Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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!

share|improve this question
add comment

1 Answer 1

up vote 9 down vote accepted

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
share|improve this answer
    
thank you very much! –  Ligia Sep 4 '12 at 10:44
1  
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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