Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I'm trying to write a query that excludes all entries with the zone AG but would include any blank entries. I've tried the following but it doesn't work:
Zone <> "AG" and Zone = "Null"
Any suggestions for how to build this?
Answer already given by Mapperz and JGH...
Zone <> 'AG' OR Zone IS NULL
Not sure how Zone IS NULL part is needed, but there may be hidden context.
Zone IS NULL
Required, but never shown
2 years, 2 months ago
1 year, 7 months ago