ReferenceSQL language referenceFunctionsBuilt-in functionsAlphabetical list of built-in functionsisnan functionOn this pageisnan function Applies to: Databricks SQL Databricks Runtime Returns true if expr is NaN. Syntax isnan(expr) Arguments expr: An expression that evaluates to a numeric. Returns A BOOLEAN. Examples SQL> SELECT isnan(cast('NaN' as double)); true> SELECT isnan(7); false Related functions isnotnull function isnull function
Databricks SQL