The Operator and Expression columns are used in multiple dialog boxes to filter a query.
The following operators are available
|
Operator |
Description |
|---|---|
|
= |
[default] Equal to |
|
> |
Greater than |
|
>= |
Greater than or equal to |
|
< |
Less than |
|
<= |
Less than or equal to |
|
Not Equal |
Different from |
|
In List |
Belongs to the list. For example "global", "Architecture", "proc*" finds any of these values. |
|
Not In List |
Does not belong to the list. |
|
Between |
In a range between two values. For example, (A,E) finds any values between A and E. |
|
Not Between |
Outside a range of two values. For example, (A,E) finds any values outside of the range between A and E. |
|
Empty |
Has no value. No expression is necessary with this operator. |
|
Not Empty |
Has a value. No expression is necessary with this operator. |
You can use the following wildcards in the Expression column:
|
Wildcard |
Description |
|---|---|
|
* |
Any string (from none to any number of characters). For example P* finds "protocol" and "Paris". |
|
? |
Any character. For example ????? finds "Table" and "inner" but not "Seller". |
|
\ |
Escapes the special characters *, ?, and \ . For example, \?\\ finds "?\". |