isnotnull()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns true if the argument isn't null.

Deprecated aliases: notnull()

Syntax

isnotnull(value)

Learn more about syntax conventions.

Parameters

Name Type Required Description
value scalar ✔️ 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)