LT

LT, BEFORE, LESS, <

Top  Previous  Next

 

The LT selection clause operator compares a field or evaluated expression against another field, evaluated expression or literal value and tests for the first item being less than the second. The synonyms BEFORE, LESS and < can be used.

 

 

Format

 

field LT {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 LT selection clause operator returns True if field is less 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 LT 100

 

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