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 need to identify which features have null attributes in the attribute table of a shapefile. When i try [field]= 'NULL' it selects the features with value=0 (see picture)enter image description here

Suggestions?

share|improve this question
    
It may be a bug. I'll check and let you know, eventually I will link you the ticket URL. Stay tuned. –  Giovanni Manghi Oct 24 '11 at 15:26
add comment

2 Answers 2

up vote 13 down vote accepted

Have you tried replacing the "=" with "is"? I don't have QGIS in front of me, but that is pretty common database select syntax for working with NULL values.

pedonal is NULL
share|improve this answer
add comment

Try:

Pedonal = ''

  • that should work!
share|improve this answer
    
that works for text fields...i'm using numerical fields, and that selects values = to 0 –  vascobnunes Oct 24 '11 at 15:48
3  
@Darren Cope, NULL is different than "" –  artwork21 Oct 25 '11 at 14:25
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.