isnotempty()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns true if the argument isn't an empty string, and it isn't null.

Deprecated aliases: notempty()

Syntax

isnotempty(value)

Learn more about syntax conventions.

Parameters

Name Type Required Description
value scalar ✔️ The value to check if not empty or 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 isnotempty(BeginLat) and isnotempty(BeginLon)