isnotnull function

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

Returns true if expr is not NULL.

Syntax 

isnotnull(expr)

Arguments

  • expr: An expression of any type.

Returns

A BOOLEAN.

This function is a synonym for expr IS NOT NULL.

Examples 

> SELECT isnotnull(1);
 true