| Logical Operators | |
| = | Equal to |
| != or <> | Not equal to |
| > | Greater than |
| >= | Greater than or equal to |
| < | Less than |
| <= | Less than or equal to |
| in | Equal to any item in a list |
| not in | Not equal to any item in a list |
| between | Between two values, greater than or equal to one and less than or equal to the other |
| not between | Not between two values |
| begins with | Begins with specified value |
| contains | Contains specified value |
| not contains | Does not contain specified value |
| is null | Is blank |
| is not null | Is not blank |
| like | Like a specified pattern. % means any series of characters. _ means any single character. '%Fred%' |
| not like | Not like a specified pattern. % means any series of characters. _ means many single character. |