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.