IS_NOT_NULL

All functions > COMPARISON > IS_NOT_NULL

Returns TRUE if the expression does NOT evaluate to NULL.

Signatures

Returns: TRUE if expr is not NULL, FALSE otherwise

IS_NOT_NULL(expr: T) → BOOLEAN

Notes

• Opposite of IS_NULL function
• Only reliable way to test for non-NULL values
• Using != NULL always returns NULL, not TRUE/FALSE
• Works with any data type
• Never returns NULL itself - always Returns TRUE or FALSE
• Can use operator syntax: expression IS NOT NULL