IS NULL
Description
<input> IS NULL
evaluates to true when the input is NULL, and false otherwise. The output can be negated by using <input> IS NOT NULL
.
IS NULL should not be confused with the predicate function ISNULL, which returns an INT instead of a boolean.
IS [NOT] NULL
can be used in the following contexts:
CASE WHEN (in the
WHEN
conditions)Pull-Up-Functions (in the filter argument)
BIND_FILTERS (in the filter argument)
CALC_REWORK (in the filter argument)
Syntax
input IS NULL
input IS NOT NULL
Examples
[1] | ||||||||||||||||
| ||||||||||||||||
|
[2] | |||||||||||||||
| |||||||||||||||
|
[3] | |||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||
|