Filter
Top Products
Column Description
Test Test is the logical condition for data selection. One of the following can
be specified:
EQ Test is positive when the content of the field is equal to the
value. For example,
PRICE EQ 2
Records are selected if the field PRICE contains a value of
200.
NE Test is positive when the content of the field is not equal to
the value.
LE Test is positive when the content of the field is less than or
equal to the value.
GE Test is positive when the content of the field is greater than
or equal to the value.
LT Test is positive when the content of the field is less than the
value.
GT Test is positive when the content of the field is greater than
the value.
RANGE Test is positive when the content of the field is between or
equal to one of the two values.
PRICE RANGE 1 3
| Records are selected if the field PRICE contains a value
| between 99 and 301. This is the same as the following:
PRICE GE 1
AND PRICE LE 3
180 AFP Utilities for AS/400 User’s Guide