WHERE - NULL

Syntax

... col IS [NOT] NULL ...

Effect

This expression is true if the value of col is (not) the null value. When using this expression, the SELECT statement bypasses SAP buffering.

Note

All other logical expression of the WHERE condition are unknown if a participating column contains the null value.