4D Doc Center : between

4D v13.4

between_predicate



	arithmetic_expression [NOT] BETWEEN arithmetic_expression AND arithmetic_expression

Description

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.

Example

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'