Edit

isnotnull()

  • Article
  • 2 minutes to read

Returns true if the argument isn't null.

Deprecated aliases: notnull()

Syntax

isnotnull(value)

Parameters

Name Type Required Description
value scalar ✓ The 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.

Run the query

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