Redigera

Dela via

isnotnull()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft 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.

Run the query

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