IS [NOT] NULL

Purpose

This tests whether an expression is a NULL value.

SELECT null=null, null IS NULL, '' IS NOT NULL;