Set Operators

Symbol Function Meaning Example
& Intersection AND For this operator to return true, both values left and right of it must be true
PRICE > 10 & QTY > 100     true if both price > 10 and qty > 100
| Union OR For this operator to return true, either left or right or both values must be true
PRICE > 10 | QTY > 100      true if price > 10 or qty > 100
± Difference XOR For this operator to return true, either left or right but not both values must be true
PRICE > 10 ± QTY > 100     true if price > 10 or qty > 100 but not both
¬ Complement NOT For this operator to return true, the value after it must be false
¬ PRICE > 10                       true if price > 10 is not true

A shortcut for typing the set operator | on a keyboard is ++

A shortcut for typing the set operator ¬ on a keyboard is – –

Close Menu