isnotnull()

Learn how to use the isnotnull() function to check if the argument isn’t null.

Returns true if the argument isn’t null.

Syntax

isnotnull(value)

Parameters

NameTypeRequiredDescription
valuescalar✔️The value to check if not null.

Returns

true if value isn’t null and false otherwise.

Example

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

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