Depending on your database, may include IS NULL and IS NOT NULL.
Table 50. Examples
S.EMP.COMM IS NULL
Retrieves employees who did not earn a commission.
S.ORDERS.TERMS IS NOT NULL
Retrieves orders with terms specified.