| Return records that have an exact value in a given field. |
= |
=10 |
Returns records where the specified field value is 10. |
| Return records where the value in a given field is the sum of the specified values. |
+ |
=8+2 |
Returns records where the specified field value is the sum of 8 and 2, or 10. |
| Return records where the value in a given field is the difference between the specified values. |
- |
=11-1 |
Returns records where the specified field value is the difference between 11 and 1, or 10. |
| Return records where the value in a given field is the outcome of the specified values after they are divided. |
/ |
=20/2 |
Returns records where the specified field value is the outcome of 20 divided by 2, or 10. |
| Return records where the value in a given field is the outcome of the specified values after they are multiplied. |
* |
=5*2 |
Returns records where the specified field value is the product of 5 multiplied by 2, or 10. |
| Return records that have a value greater than the specified value in a given field. |
> |
>9 |
Returns records where the specified field value is greater than 9. |
| Return records that have a value less than the specified value in a given field. |
< |
<11 |
Returns records where the specified field value is less than 11. |
| Return records that have a value greater than or equal to the specified value in a given field. |
>= |
>=10 |
Returns records where the specified field value is greater than or equal to 10. |
| Return records that have a value less than or equal to the specified value in a given field. |
<= |
<=10 |
Returns records where the specified field value is less than or equal to 10. |
| Return records that do not have the specified value in a given field. |
Not
!=
<>
|
Not 10
!= 10
<> 10
|
Returns records where the specified field value is not 10. |
| Returns records that have multiple values in a given field. |
And |
<5 And >1 |
Returns records where the specified field value is less than 5 and greater than 1. |
| Return records that have one value or another in a given field. |
Or |
5 Or 10 |
Returns records where the specified field value is 5 or 10. |
| Return records that have a value similar to the specified value. |
Like |
Like '10%' |
Returns records where the specified field value starts with the digits 10, followed by any number of other digits, such as 234 (10234). |
| Return records that have a value similar to the specified value. |
Like |
Like '10_' |
Returns records where the specified field value starts with the digits 10 followed by any one digit, such as 0 (100). |
| Return records that do not have a value similar to the specified value. |
Not Like |
Not Like '10%' |
Returns records where the specified field value does not start with the digits 10 followed by any number of additional digits. For example, this would eliminate values 100 and above.
|
| Return records that do not have a value similar to the specified value. |
Not Like |
Not Like '10_' |
Returns records where the specified field value does not start with the digits 10 followed by any one digit. For example, this would eliminate values 100 through 109.
|
| Return records where a given field contains a value that results from a specified grouping. |
() |
(1000+1)-1 |
Returns records where the specified field value is equal to 1000 plus 1, or 1001, minus 1, which equals 1000. |
| Return records that contain any value in a given field. |
Is Not Null |
Is Not Null |
Returns records where the field is not empty. |
| Return records that do not contain any values in a given field. |
Is Null |
Is Null |
Returns records where the field is empty. |
| Return records that contain the specified values in a given field. |
In |
In (5, 10, 20) |
Returns records where the specified value is 5, 10, or 20. |
| Return records that do not contain the specified values in a given field. |
Not In |
Not In (5, 10, 20) |
Returns records where the specified field value is not 5, 10, or 20. |
