Applies to: CELONIS 4.0CELONIS 4.2CELONIS 4.3CELONIS 4.4CELONIS 4.5CELONIS 4.6
Description
Predicate functions and operators check if the input argument satisfies a condition.
Predicate Function
The ISNULL function checks if the input value is NULL
and returns 1 if the input value is NULL, and 0 (as an INT) otherwise.
Predicate Operators
Predicate operators may match the values of a column with a list of match values
(IN) or a match pattern
(LIKE) and return true if the value of a column
matches.
The BETWEEN operator matches an
inclusive range between two given values.
In contrast to the ISNULL function, which returns an INT, the
IS NULL operator
returns true if the input is NULL, and false otherwise.
The output of IN, LIKE, BETWEEN and IS NULL can be negated by using
NOT IN, NOT LIKE, NOT BETWEEN and IS NOT NULL respectively.
IN,
LIKE,
BETWEEN and
IS NULL must be used together with one of the
following operators which are evaluating the return value: