4D v13.4

between_predicate

Home

 
4D v13.4
between_predicate

between_predicate  


 

 

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.

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'

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

arithmetic_expression
predicate