is_null

Description

Return true if the argument has the null value.

Return type

bool

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

is_null(arg)

Argument

Type

Optional

Repeatable

Restrictions

arg

scalar

no

no

none

Examples

filter not is_null(path)

This filters a dataset to remove any lines where path is null.

Aliases

isnull (deprecated)