Permitted Relational Operation
Symbols
EQ = True if the two value expressions are
equal.
NE <> True if the two value expressions are not
equal.
GT > True if the first value expression is
greater than the second.
GE >= True if the first value expression is
greater than or equal to the second.
LT < True if the first value expression is less
than the second.
LE <= True if the first value expression is less
than or equal to the second.
BETWEEN True if the first value expression is
between the second and third or equal to
one of them.
ANY True if the record stream specified by the
RSE includes at least one record. If you
add NOT, the condition is true if there are
no records in the record stream.
MATCHING True if the second expression matches a
substring of the first value expression.
MATCHING uses these special characters:
* Matches any string
% Matches any character
MISSING True if the value expression is null.
UNIQUE True if the record stream specified by the
RSE includes only one record. If you add
NOT, the condition is true if there is more
than one record in the record stream or the
record stream is empty.
CONTAINING True if the string specified by the second
string expression is found within the
string specified by the first. Not
case sensitive.
STARTING WITH True if the first characters of the first
string expression match the second string
expression. Case sensitive.