isnotempty()
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft 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)