Previous Topic: ConditionNext Topic: Examples


Syntax

expression-1 co expression-2 [lo expression-3 co expression-4 ...]

where:

expression-1, expression-2, and, optionally, expression-3 and expression-4 specify an expression whose value is compared. In addition, expression-2 and expression-4 can contain a list of expressions (for example, ('ABC','DEF',...)). Enclose the list of expressions in parentheses.

co is a comparison operator as follows:

= equal
EQ equal
^= not equal
<> not equal
>< not equal

NE not equal
< less than
LT less than
> greater than
GT greater than
^< greater than or equal to (not less than)
<^ greater than or equal to (not less than)
>= greater than or equal to

=> greater than or equal to
GE greater than or equal to
^> less than or equal to (not greater than)
>^ less than or equal to (not greater than)
<= less than or equal to
=< less than or equal to
LE less than or equal to

lo is a logical operator as follows:

AND Conditions on both sides of the logical operator must be true
& Same as AND
OR Either condition surrounding the logical operator can be true
| Same as OR

A condition is broken down into groups separated by the OR logical operator if there is any. If this group or any one of these groups is evaluated as true, the total condition is evaluated the same. The process of grouping can be altered by enclosing a portion or portions of the condition in parentheses.