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?


Have you tried

paoText is NULL


paoText is not NULL
  • 2
    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
  • 1
    Six years later, and is is still not one of the options from the list of standard operators in the query builder field... Seems that it would be commonly used by most people to select empty or only filled fields – user3386170 Sep 13 '18 at 20:20

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.