Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
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)