LE, <=, =<

The LE 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 or equal to the second. The synonyms <= and =< can be used.

Format

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

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