Using arithmetic operators to narrow your search
In a find request, you can make your search more specific by using arithmetic signs (operators) to find values relative to a value you specify.
|
|
|
|
|
|
| |
To find values that are |
|
Use this operator |
|
Example |
|
|
|
|
|
|
|
|
|
|
|
|
|
Less than |
|
< |
|
"<250" finds all values less than 250 |
|
|
Greater than |
|
> |
|
">250" finds all values greater than 250 |
|
|
Less than or equal to |
|
<= |
|
"<=250" finds 250 and all values less than 250 |
|
|
Greater than or equal to |
|
>= |
|
">=250" finds 250 and all values greater than 250 |
|
|
An exact match |
|
= |
|
"=Dan" finds Dan but not Daniel |
|
|
Not equal to |
|
<> |
|
"<>7" finds all values except 7 |
|
Related topic
|