The sql-expressions must be of compatible data types. They must be either all numeric or all character types. Because a BETWEEN condition evaluates the boundary values as a range, it is not necessary ...

An IN condition tests if the column value that is returned by the sql-expression on the left is a member of the set (of constants or values returned by the query-expression) on the right. If so, it ...

SQL Conditional Statements Additionally, you can use the statements BETWEEN and LIKE for comparison with the WHERE clause, and any combination of comparisons with the operators AND and OR.