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.
If expr is a VARIANT result of a:
- JSON path expression with a valid path,
- parse_json function,
- variant_explode table-valued function, or
- variant_explode_outer table-valued function
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