GE

GE, >=, =>

Top  Previous  Next

 

The GE selection clause operator compares a field or evaluated expression against another field, evaluated expression or literal value and tests for the first item being greater than or equal to the second. The synonyms >= and => can be used.

 

 

Format

 

field GE {NO.CASE} value

 

where

 

fieldis the first field or evaluated expression to be compared.

 

valueis the second field, evaluated expression or literal value to be compared. The optional NO.CASE qualifier causes a case insensitive comparison to be applied.

 

 

The GE selection clause operator returns True if field is greater than or equal to value. For right aligned fields (typically numeric values) a numeric comparison will be used if the field content and value are both integer values. The QUERY.STR.COMP.ALL modes of the OPTION command can be used to apply string character comparisons to all data.

 

 

Example

 

LIST STOCK WITH QTY GE 100

 

This command lists items found on the STOCK file with a QTY field of 100 or over.