IS_NULL (Azure Cosmos DB)
APPLIES TO:
NoSQL
Returns a Boolean value indicating if the type of the specified expression is null.
Syntax
IS_NULL(<expr>)
Arguments
expr
Is any expression.
Return types
Returns a Boolean expression.
Examples
The following example checks objects of JSON Boolean, number, string, null, object, array, and undefined types using the IS_NULL
function.
SELECT
IS_NULL(true) AS isNull1,
IS_NULL(1) AS isNull2,
IS_NULL("value") AS isNull3,
IS_NULL(null) AS isNull4,
IS_NULL({prop: "value"}) AS isNull5,
IS_NULL([1, 2, 3]) AS isNull6,
IS_NULL({prop: "value"}.prop2) AS isNull7
Here is the result set.
[{"isNull1":false,"isNull2":false,"isNull3":false,"isNull4":true,"isNull5":false,"isNull6":false,"isNull7":false}]
Remarks
This system function will benefit from a range index.
Next steps
Feedback
Submit and view feedback for