between_predicate

version 11

arithmetic_expression [NOT] BETWEEN arithmetic_expression AND arithmetic_expression

A between_predicate is used to find data with values that fall within two other arithmetic_expression values (passed in ascending order). You can also pass the optional NOT keyword to excludes values falling within these limits.

Here is a simple example which returns the names of all the clients whose first name starts with a letter between A and E:

   SELECT CLIENT_FIRSTNAME, CLIENT_SECONDNAME
    FROM T_CLIENT
   WHERE CLIENT_FIRSTNAME BETWEEN 'A' AND 'E'

arithmetic_expression, predicate.