Skip to content

Developer Edition runs on one host and does not require a product license file. Need multi-host deployment or performance testing at scale? Explore Enterprise Edition

Null predicate¶

The null predicate checks if a value is null or not.

Syntax¶

diagramsource

null_predicate

null_predicate ::= 
    value_expression 'IS' 'NOT'? 'NULL'

Parameters¶

`value_expression`¶

The value expression that is checked for null.

Examples¶

Check if a value is null¶

LET a= null>10 RETURN a IS NULL AS a_is_null

Return:

+-----------+
| a_is_null |
+-----------+
| true      |
+-----------+