Db2 for i SQL: Multiple search conditions within a WHERE clause - IBM
Multiple search conditions within a WHERE clause. You can qualify your request further by coding a search condition that includes several predicates. The search condition you specify can contain any of the comparison operators or the predicates BETWEEN, DISTINCT, IN, LIKE, EXISTS, IS NULL, and IS NOT NULL. You can combine any two predicates ...