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.
StormEvents
| where isnotnull(BeginLat) and isnotnull(BeginLon)