GT

GT, AFTER, GREATER, >

Top  Previous  Next

 

The GT 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 the second. The synonyms AFTER, GREATER and > can be used.

 

 

Format

 

field GT {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 GT selection clause operator returns True if field is greater than 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 GT 100

 

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