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 an OS AddressBase shape file. One of the attributes is 'paoText'. It is either a text string like 'Anchor House' or is NULL.

I want to extract all the records where there is a text string i.e. the attribute is not NULL.

I have tried Advance search with paoText = NULL with the idea of inverting the result to get all those records that contain text i.e. a property name, but my search returns nill records.

I know there are records with NULL in that attribute because I can see them. What am I doing wrong please?

share|improve this question
1  
Possible duplicate of gis.stackexchange.com/questions/16134/… –  Rayner Oct 6 '12 at 20:02
add comment

1 Answer 1

up vote 5 down vote accepted

Have you tried

paoText is NULL

or

paoText is not NULL
share|improve this answer
1  
Thanks Rayner those are both answers that work. I hadn't tried those, only the Operators show in the list which does not include IS. I didn't realise I could use IS on its own or with NOT. Thank you –  Nigel Law Oct 6 '12 at 20:55
    
Glad I could help. –  Rayner Oct 6 '12 at 21:16
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.