Reference: Sort operators
A sort operator is a symbol that instructs the soft to perform an action in an expression (selection statement). For example, the expression, key1=red & key3>5, extracts only the records where the information in the first sort key is red and the information in the third sort key is greater than five. When you define a sort definition, you can use sort operators.
When you define the criteria for a sort definition, you can use the sort operators listed in the following table.
|
Symbol
|
What It Does
|
|
|
|
Selects records that meet the conditions of either key.
|
|
&
|
Selects records that meet the conditions of both keys.
|
|
=
|
Selects records that have the same information in an indicated key.
|
|
<>
|
Selects records that do not match the information for an indicated key.
|
|
>
|
Selects records that have information greater than the information for an indicated key.
|
|
<
|
Selects records that have information less than the information for an indicated key.
|
|
>=
|
Selects records that have information greater than or equal to the information for an indicated key.
|
|
<=
|
Selects records that have information less than or equal to the information for an indicated key.
|
|
key g
|
Selects records that contain the word you specify anywhere in the record (global search).
|
|
•
|
|
Each line of text is a field that can be divided into two or more fields using tabs and indents.
|
|
•
|
|
In merge records, fields end with the ENDFIELD code.
|
Reference: Sort operators