Progress
SQL-92
Guide and Reference


BETWEEN Predicate

The BETWEEN predicate can be used to determine if a value is within a specified value range or not. The first expression specifies the lower bound of the range and the second expression specifies the upper bound of the range.

The predicate evaluates to true if the value is greater than or equal to the lower bound of the range and less than or equal to the upper bound of the range.

This is the syntax for a between_predicate:

SYNTAX
expression [ NOT ] BETWEEN expression AND expression 

EXAMPLE

salary BETWEEN 20000.00 AND 100000.00 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095