isnotnull function

Applies to: Databricks SQL 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.

Examples

> SELECT isnotnull(1);
 true

Related functions

• isnull function

• isnan function

• is null operator