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

Copy
isNull(<type> expr field)

• field : an expression evaluating to any Incorta type

Returns

bool

Example

Determine whether the expression COUNTRY_NAME evaluates to NULL.

Copy
isNull(SALES.COUNTRY_NAME)