IS [NOT] NULL

Purpose

This tests whether an expression is a NULL value.

Syntax

IS NOT NULL Predicate

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