The GE (greater than or equal to) function determines whether a value is greater than or equal to another value. If the first value specified is greater than or equal to than the second value specified, a true (1) is returned. Otherwise, a false (0) is returned. The GE function operates in the opposite manner as the LE function. The greater than or equal to symbols (>=) can also be used to perform this function and is the recommended method.
Category
Boolean
Syntax
GE(value1, value2) or value1>=value2
Parameters and Descriptions
| Parameter | Description |
|---|---|
| value1 | This parameter specifies the first value to be used in the greater than or equal to comparison. This value may be a field/column of a datastore, a literal value (i.e. ABC) or the result of another Function. |
| value2 | This parameter specifies the second value to be used in the greater than or equal to comparison. The source value may be a field/column of a datastore, a literal value (i.e. ABC) or the result of another Function. |
| 1 | 0 | Indicates whether a TRUE (1) or FALSE (0) was returned from the GE function. |
Example
Compare an employee’s yearly salary (YR_WAGE) to determine who is being paid $75,000 or more per year. If this condition is true, set variable HIGH_PAID to the constant Y. Otherwise, set the variable HIGH_PAID to the constant N.
CASE
WHEN YRWAGE >= '75000'
{
V_HIGH_PAID = 'Y'
}
OTHERWISE
{
V_HIGH_PAID = 'N'
}