isNull

Returns true if its argument is NULL.

Example

Determine whether the expression COUNTRY_NAME evaluates to NULL.

isNull(SALES.COUNTRY_NAME)

Syntax

isNull(<type> expr field)

• field : an expression evaluating to any Incorta type

  Returns

  bool

Notes

Function isNull evaluates its expression argument and returns true if it is NULL and false otherwise.