![Next: IS [NOT] DISTINCT FROM](images/next-or18.png "Next: IS [NOT] DISTINCT FROM"){kind=small}
| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → Operators and predicates → 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.0 Language Ref. Update → Operators and predicates → IN |