NULL represents unknown, so comparisons like = NULL do not evaluate to true.

Use IS NULL or IS NOT NULL. NULL also affects joins, filters, aggregates, and three-valued logic, so explicit handling prevents subtle bugs.