Built-in Functions → isNull
isNull() is a boolean function that evaluates its expression argument and returns true if it is NULL and false otherwise.
Signature
isNull(<type> expr field)
- field : an expression evaluating to any Incorta type
Returns
bool
Example
Determine whether the expression COUNTRY_NAME evaluates to NULL.
isNull(SALES.COUNTRY_NAME)