NOT CONTAINS operator is used to evaluate whether a particular set of values includes a given value.
<set> CONTAINS <value>
<set> NOT CONTAINS <value>
- A set of values to consider.
- If the set contains the provided value. This includes if the value provided is null and the set contains at least one null. Or (
FALSEin the case of the
- If the set does not contain the value and the set does not contain any nulls. Or (
TRUEin the case of the
- If the set contains at least one null and does not contain the value provided (and the value is not null).
DATABASES CONTAINS "MY DATABASE"
DATABASES CONTAINS null
DATABASES NOT CONTAINS null