You can use the WHERE clause to filter the required data. The options available are similar to those provided for Access queries with slightly different syntax. There are certain differences, especially for the specification of date and time, character strings, and placeholders, as described in the following sections.
You can use the comparison operators described in Table 9-14.
|!=||Not equal to|
|<>||Not equal to|
|<=||Less than or equal to|
|!<||Less than or equal to|
|>=||Greater than or equal to|
|!>||Greater than or equal to|
|BETWEEN expr1 AND expr2||Between expr1 and expr2|
|IS [NOT] NULL||Is (not) equal ...|