IS NULL Clause (Spider)

[Table of Contents](https://github.com/dell-oss/Doradus/wiki/Spider Databases: Table-of-Contents) | Previous | Next
Doradus Query Language: IS Null Clause

---

A scalar or link field can be tested for nullity by using the clause field IS NULL. Examples:

LastName IS NULL
InternalRecipients IS NULL
Sender.MessageAddress.Person.Manager IS NULL

The last example above uses a link path (described later). See the section Quantifier Functions for examples of how IS NULL interacts with quantified link paths.

An IS NULL clause can be negated with NOT as a clause prefix:

NOT LastName IS NULL
NOT InternalRecipients IS NULL
NOT Sender.MessageAddress.Person.Manager IS NULL