![Next: IS [NOT] DISTINCT FROM](images/next-or18.png "Next: IS [NOT] DISTINCT FROM"){kind=small}
| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Operators and predicates → IN |
|
|
|
Table of Contents
Find a more recent version at Firebird 5.0 Language Reference: IN
Available in: DSQL, ESQL, PSQL
Changed in: 2.0
Description: The IN predicate now allows NULL literals,
both as the test value and in the list. Notice that this brings no practical benefits. In
particular, “NULL IN (...,
NULL, ..., ...)” will not return true and
“NULL NOT
IN (..., NULL, ..., ...)” will not return
false.
|
| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Operators and predicates → IN |