Return to Question

Adjusted format of code line for readability

Source Link

edited Dec 3, 2017 at 18:06

31.2k
6
74
155

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"

Zone <> "AG" and Zone = "Null"

Any suggestions for how to build this?

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?

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?

Source Link

asked May 16, 2017 at 15:21

Aurust

QGIS SQL Query for Blank

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?

qgis sql