IS_NULL
All functions > COMPARISON > IS_NULL
Returns TRUE if the expression evaluates to NULL.
Syntax
IS_NULL(expression: T) → BOOLEANsql
Type Parameters:
T: Any type
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
expression | T | Yes | Expression to test for NULL |
Returns
BOOLEAN - TRUE if NULL, FALSE otherwise
Notes
- Only reliable way to test for NULL values
- Using
= NULLor!= NULLalways 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 NULL