ISNULL

Returns true if the argument is NULL.

Syntax

ISNULL ( expression ) 

Arguments

expression
A column expression or value.

Return Type

Returns data of type BOOL.

Examples

Examples in this section use the example blockchain.

The following example returns true if the value from real is NULL. Otherwise, it returns false.

SELECT ISNULL(real) FROM example;

Response:

ISNULL(real) [FLOAT32]
true
false
false
false