Boolean Query Syntax (Venn Diagrams) | |
Symbol | Description |
> | greater than |
>= | greater than or equal |
<> | not equal |
>=10 AND <=90 | range |
* | wildcard (group of characters) |
? | wildcard (one character) |
AND | both criteria true |
OR | either one true |
Xor | one or other true, but not both |
Not | untrue to match |
Is Null | display empty fields |
Is Not Null | display non-empty fields |