The BETWEEN function determines whether or not a value is greater than one value and less than another value, inclusive of the lower and upper comparison values. If the value being tested falls between the upper and lower test values, inclusive, a true (1) is returned. Otherwise, a false (0) is returned.
Category
Boolean
Syntax
BETWEEN(<source_value>, <lower_value>,<upper_value>)
Parameters and Descriptions
| Parameter | Description |
|---|---|
| source_value | The value to be tested by the BETWEEN function against the test values to determine if it is greater than the first test value and less than the second test value, inclusive. |
| lower_value | This parameter specifies a value that serves as the lower limit of the BETWEEN test. This value can be expressed as the contents of a source field/column, a function/function set or as a constant. |
| upper_value | This parameter specifies a value that serves as the upper limit of the BETWEEN test. This value can be expressed as the contents of a source field/column, a function/function set or as a constant. 1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the BETWEEN function. |
Example
Determine if the value of SOURCE_FLD1 is between 1 and 10, inclusive. If the condition is true, set the variable CHECK to the constant Y. Otherwise, set the variable CHECK to N.
IF BETWEEN(SOURCE_FLD1, 1, 10)
{
V_CHECK = 'Y'
}
ELSE
{
V_CHECK = 'N'
}