Figure 1: Select Operator
"Select Operator" combo box is used to apply an operator on the selected field. "Select Operator" contains the following operators:
| 1. | is any value: This filter can be applied when no filter is to be applied on a field.
|
| 2. | is equal to: This will bring only those records that match the criteria against "is equal to" e.g. ID is equal to 4 will bring only those records where ID is equal to 4.
|
| 3. | is not equal to: This will bring only those records that match the criteria against "is not equal to" e.g. ID is not equal to 4 will bring all those records where ID is not equal to 4.
|
| 4. | is one of: When "is one of" is selected, user has to press the add button to add the values to the list. If any of the values matches, the record is brought. e.g. ID is one of 4, 5, 6 will bring all those records where ID is equal to 4 or ID is equal to 5 or ID is equal to 6.
|
| 5. | is not one of: Same as above but the difference is that it will not bring those records that have been added in the list.
|
| 6. | is less than: This will bring all the records that are less than the specified value. E.g., ID is less than 5 will bring all the records where ID value is less than 5 in the database. Note: that it will not bring a record with ID value equals to 5. In other words, the specified value is exclusive.
|
| 7. | is less than equal to: Same as above but with the difference that it will bring the specified value as well. E.g. ID is less than or equal to 5 will bring all those records where ID is 5 or less. Note that in this case, the specified value is inclusive.
|
| 8. | is greater than: This will bring all the records that are greater than the specified value. E.g., ID is greater than 5 will bring all the records where ID value is greater than 5 into the database. Note that it will not bring a record with ID value equals to 5. In other words, the specified value is exclusive.
|
| 9. | is greater than equal to: Same as above but with the difference that it will bring the specified value as well. E.g., ID is greater than or equal to 5 will bring all those records where ID is 5 or greater than 5. Note that in this case, the specified value is inclusive.
|
| 10. | is between: This will bring the records between the specified limits. E.g., ID is between 5 and 7 will bring records where ID value is between 5 and 7. Note that in this operator, upper and lower values are inclusive. In other words it will bring records for ID equals to 5 and 7 as well if they exist in the database.
|
| 11. | is not between: Same as above with the difference that it will bring all the values that are not there in the specified range. This operator is inclusive too.
|
| 12. | is like & is not like: These operators are only visible in "Select Operator" combo box if the user selects a column from "Select Column" combo box whose data type in the database is Text. These operators work exactly like the SQL operators Like and Not Like, respectively – note that the SQL version and dialect of the underlying provider affects what syntax may be used for these operators. The operators allow users to use wild cards in filters. Refer to the following table for simple wild card characters that maybe used with Access and SQLServer databases.
|
Consult the SQL documentation for a more detailed list of possible wild card options and their usage:
|
Operation
|
SQLServer
|
Access
|
|
Match any string
|
%
|
*
|
|
Match any character
|
_
(Underscore character) |
?
|