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)