Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
Possible duplicate of… – Rayner Oct 6 '12 at 20:02
up vote 6 down vote accepted

Have you tried

paoText is NULL


paoText is not NULL
share|improve this answer
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 – nigellaw Oct 6 '12 at 20:55
Glad I could help. – Rayner Oct 6 '12 at 21:16

Your Answer


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.