GT, AFTER, GREATER, >

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

field

is the first field or evaluated expression to be compared.

value

is 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.