A field with a NULL value is a field with no value.

If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field. Then, the field will be saved with a NULL value.

Test for NULL Values

use IS NULL and IS NOT NULL operators

SELECT * FROM Customers
WHERE City IS NULL

SELECT * FROM Customers
WHERE City IS NOT NULL