Operator Functionality

The following operators are available when building query criteria:

1. Exactly Equals - the value of the selected field exactly equals the value entered (not case-sensitive).

2. Not Exactly Equal To - the value of the selected field does not exactly equal the value entered (not case-sensitive).

3. Greater Than - the value of the selected field is greater than the value entered.

4. Greater Than or Equal - the value of the selected field is greater than or equal to the value entered.

5. Less Than - the value of the selected field is less than the value entered.

6. Less Than or Equal -  the value of the selected field is less than or equal to the value entered.

7. Between - the value of the selected field is in between the two values entered.

8. Not Between - the value of the selected field is not between the two values entered.

9. In List - the value of the selected field can be found in the list of values entered. Two fields display when this operator is selected. When data is entered in the last field, an additional field will display to enter more values.

10. Not In List - the value of the selected field is not found in the list of values entered.

11. Not Set - the value of in the selected field is NULL (empty). If this operator is selected, the Value box will be disabled.

12. Is Set - the value in the selected field is not NULL (not empty). If this operator is selected, the Value box will be disabled.

13. In Results - this operator is used to specify that you would like to see records that are in a specific result set.