4D v16

between_predicate

Home

 
4D v16
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'



Siehe auch 

arithmetic_expression
predicate

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: Syntax rules

 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)