isnull()
Evaluates its sole argument and returns a bool
value indicating if the argument evaluates to a null value.
Note
String values can't be null. Use isempty to determine if a value of type string
is empty or not.
Syntax
isnull(
Expr)
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.
x | isnull(x) |
---|---|
"" |
false |
"x" |
false |
parse_json("") |
true |
parse_json("[]") |
false |
parse_json("{}") |
false |
Example
Find the storm events for which there's not a begin location.
StormEvents
| where isnull(BeginLat) and isnull(BeginLon)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for