One type of criteria allows the SQL statement to filter a field for data that is equal to, not equal to, greater than, or less than a value you specify. Some combinations of these comparators are also supported.
Symbol |
Comparison |
|
Symbol |
Comparison |
= |
Equal to |
|
<> |
Not equal to |
> |
Greater than |
|
>= |
Greater than or equal to |
< |
Less than |
|
<= |
Less than or equal to |
In the following example, only data where the Order ID is greater than 10,000 will pass the filter and be acted upon by the query: