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, May 26 '22 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, May 26 '22 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, May 26 '22 at 16:25

MrXsquared · Answer 1 · 2022-05-26T17:24:25.173

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

edited May 26 '22 at 17:24

answered May 26 '22 at 16:05

MrXsquared

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

1 Answers1