# How to select features where attribute is not NULL?

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


or

paoText is not NULL

• 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
• 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

The solution below worked with my data:

paoText <> ' '