IS_NULL
All functions > COMPARISON > IS_NULL
Returns TRUE if the expression evaluates to NULL.
Signatures
Returns: TRUE if expr is NULL, FALSE otherwise
IS_NULL(expr: T) → BOOLEANsql
| Parameter | Type | Required | Description |
|---|---|---|---|
expr | T | Yes | Expression to test for NULL |
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
On this page