Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
<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:
input IS NULL
input IS NOT NULL
[1] |
[2] |
[3]
|