ISNULL

Syntax

As a function

ISNULL( expression )

As an operator

expression IS [ NOT ] NULL

Description

Returns TRUE if expression is NULL, otherwise returns FALSE.

expression IS NOT NULL returns the opposite result.

Argument types:

  • expressionAny

Return type: Boolean

Example

[sales] ISNULL([sales]) [sales] IS NULL [sales] IS NOT NULL
432.40 False False True
77.00 False False True
12000.00 False False True
NULL True True False
34.25 False False True
128.00 False False True
0.00 False False True
NULL True True False

Data source support

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Previous
Next