Values can be either numbers or strings. It is usually not necessary to place strings in quotes. Ranges of values can be specified by giving the endpoints of the ranges separated by a colon. Ranges include their endpoints. Ranges can also be used with strings as well as numbers.
Ranges can also be one sided.
A filter can contain a list of single values and ranges. The values in the list should be enclosed in parentheses. Filters can test more than one column in a table. The individual tests are separated by commas or semicolons. All tests in the filter must succeed for the filter to be accepted.