| World Wide Widgets |
| % | "wild card" matches zero or more characters (use anywhere in input) |
| _ | (underline) "wild card" matches any single character (use anywhere in input) |
| > | greater than (use before a value) |
| < | less than (use before a value) |
| = | equal to (the default, use before a value with actual %) |
| >= | greater than or equal (use before a value) |
| <= | less than or equal (use before a value) |
| <> | not equal (use before a value) |
For the following options, put 'character data' in 'apostrophes'. At least one space between operator and value is required.
| like | character pattern match (default if % used) |
| not like | character pattern not like |
| between X and Y | field value bounded by limits |
| not between X and Y | field value not within limits |
| in (X,Y,Z,..) | field in listed values |
| not in (X,Y,Z,...) | field not in listed values |