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?
Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
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.
andbetween the two terms