ISNAN

​

Syntax

​

Scalar

isnan(value)

​

Arguments

​

Returns

• Type: BOOLEAN
• Possible values: TRUE for floating-point NaN; FALSE for other non-NULL numeric values.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Usage notes

• Integer and decimal values are never NaN.
• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.

​

Examples

​

Value and NULL input

SELECT isnan(CAST(1 AS DOUBLE)) AS "value", isnan(CAST(NULL AS DOUBLE)) AS null_value;

​

NaN and ordinary numbers

SELECT isnan(CAST('NaN' AS DOUBLE)) AS not_a_number, isnan(CAST(2.5 AS DOUBLE)) AS ordinary_number;