A Logical CCL operator combines the results of two Boolean expressions or conditions to produce a single result, or inverts the result of a single condition.
The following table describes logical operators:
|
Operator |
Purpose |
|---|---|
|
NOT |
Returns true if the following condition is false. Returns false if it is true. |
|
AND |
Returns true if both component conditions are true. Returns false if either is false. |
|
OR |
Returns true if either component condition is true. Returns false if both are false. |
|
XOR |
Returns true if one component condition is true and the other is false. Returns false if both components are true or both are false. |
For details of how logical operators behave with NULL values, see Null Values in Expressions.