isnotnull function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns true if expr is not NULL. This function is a synonym for expr IS NOT NULL.

Syntax

isnotnull(expr)

Arguments

  • expr: An expression of any type.

Returns

A BOOLEAN.

If expr is a VARIANT result of a:

the result is always true. Use the is_variant_null function function to check if the VARIANT encoded value is NULL, or cast the VARIANT to a specific type and check if the result is NULL.

Examples

> SELECT isnotnull(1);
 true

> SELECT isnotnull(NULL:INTEGER);
 false

> SELECT isnotnull(parse_json('{"key": null}'):key);
 true

> SELECT isnotnull(parse_json('{"key": null}'):wrongkey);
 false

> SELECT !is_variant_null(parse_json('{"key": null}'):key);
 false