isnotnull()

Returns true if the argument isn't null.

Deprecated aliases: notnull()

Syntax

isnotnull(value)

Parameters

NameTypeRequiredDescription
valuescalarThe value to check if not null.

Returns

true if value is not null and false otherwise.

Example

Find the storm events for which there's a begin location.

StormEvents
| where isnotnull(BeginLat) and isnotnull(BeginLon)