Criteria Operators
There are many different operators that you can choose from when you are specifying criteria. The following is a list of the available operators in the Add Criteria dialog along with their respective meanings.
| Operator | Meaning | Example | Table/Field | Value(s) |
| = | Equal to | Finds records for customers in Ohio | Customers/State | Select Ohio |
| <> | Not equal to | Finds customers not in Ohio | Customers/State | Select Ohio |
| > | Greater than | Finds orders more than $100 | Orders/Price | Select 100 |
| >= | Greater than or equal to | Finds orders placed on or later than a certain date. | Orders/Date | Select Dec-99 |
| < | Less than | Finds orders less than $100 | Orders/Price | Select 100 |
| <= | Less than or equal to | Finds orders placed on or earlier than a certain date | Orders/Date | Select Nov-99 |
| Is one of | Shows values that match a list of specified values | Finds suppliers in Tulsa, Cleveland, or Dayton | Suppliers/City | Select Tulsa, Cleveland, and Dayton |
| Is not one of | Shows values that do not match a list of specified values | Finds orders that were not placed in November or December | Orders/Month | Select November and December |
| Between | Shows a range of values between and including the two endpoints | Finds employees that were hired between 1999 and 2000 | Employees/HireDate | Select 1999 and 2000 |
| Is not between | Shows values that are not between a range of values including the two endpoints | Finds orders that are not between $100 and $500 | Orders/Price | Select 100 and 500 |
| Begins with | Begins with specified value(s) | Finds zip codes that begin with 454 | Customers/ZipCode | Enter 454 |
| Does not begin with | Does not begin with specified value(s) | Finds zip codes that do not begin with 454 | Customers/ZipCode | Enter 454 |
| Ends with | Ends with specified value(s) | Finds zip codes that end in 19 | Customers/ZipCode | Enter 19 |
| Does not end with | Does not end with specified value(s) | Finds zip codes that do not end in 19 | Customers/ZipCode | Enter 19 |
| Contains | Contains specified value(s) | Finds products that contain sugar | Products/Ingredients | Select sugar |
| Does not contain | Does not contain specified value(s) | Finds products that do not contain sugar | Products/Ingredients | Select sugar |
| Is like | Uses Like and the wildcard character % to compare values | Finds names that begin with Da such as Daniel and David | Employees/FirstName | Enter Da% |
| Is not like | Shows values that do not compare to the specified character(s) and wildcard character % | Finds names that do not begin with Da | Employees/FirstName | Enter Da% |
| Is null | Determines whether a record has no value in the specified field | Finds records that do not have an entry for address | Customers/Address | |
| Is not null | Determines whether a record has a value in the specified field | Finds records that do have an entry for address | Customers/Address |
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.