OR is a logical connective used to join multiple selection expressions. OR specifies that only one of the specified conditions must be met for an item to be selected.
The AND connective takes precedence over the OR connective when both appear in the same query. This can be altered by enclosing in parentheses the selection expression that is to be evaluated first.
OR is assumed when a logical connective is not explicitly entered between two selection expressions.
Example
This example lists all customers in Maine, New Hampshire and Vermont:
|
>LIST CUSTOMERS WITH STATE = "ME" OR STATE = "NH" OR STATE = "VT" STATE |
See Also