1

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?

Improve this question
2
  • 1
    use IS NULL not =Null
    – Mapperz ♦
    Commented May 16, 2017 at 15:24
  • 1
    use or, not and between the two terms
    – JGH
    Commented May 16, 2017 at 15:32

1 Answer 1

Reset to default
1

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.

Improve this answer

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.