Select NULL values by attribute statement

Question

Having some difficulty figuring out "and" statements as i am quite new to GIS. What errors am I making in this statement here?

STATUS = 'QC Required' and WORKFROMHOMEEMPLOYEES = 'NULL'

Since we don't know your data or your intentions, we don't know. What should happen? — Erik, Commented May 26, 2022 at 15:48
id like it to select data from 'qc required' and then from the qc required records to select ones that have null values — rheesuspieces, Commented May 26, 2022 at 15:55
See What is the difference between != NULL and IS NOT NULL in QGIS filter expressions? - the answers there explain the workings of NULL — Midavalo, Commented May 26, 2022 at 16:25

MrXsquared · Accepted Answer · 2022-05-26 17:24:25Z

5

Use is Null to select Null values. By using = 'NULL' you select a string containing this word. So use:

STATUS = 'QC Required' and WORKFROMHOMEEMPLOYEES IS NULL

answered May 26, 2022 at 16:05

MrXsquared

35.2k21 gold badges67 silver badges117 bronze badges

Sounds like the CA DMV might have this bug in their ticketing system radiolab.org/episodes/null
– Michael Brown
Commented May 26, 2022 at 23:45

Add a comment |

1 Answer 1