16

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?

1

1 Answer 1

26

Have you tried

paoText is NULL

or

paoText is not NULL
3
  • 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, 2012 at 20:55
  • Glad I could help.
    – Rayner
    Oct 6, 2012 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 Sep 13, 2018 at 20:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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