Please enable JavaScript to view this site.

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

 

Parameter Descriptions

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'

}