| Text Fields |
|---|
...
Numeric Fields (e.g. Quantity)
...
| such as Symbol and Route | |
|---|---|
"" | |
...
| Empty value | |
IBM,DELL,YHOO | IBM, DELL or YHOO |
PHLX,"" |
...
PHLX or empty |
+DELL% |
...
Values that begin with +DELL |
...
EDG_ |
...
4-character values that start with EDG |
...
"123,456" |
...
The value 123,456 |
...
"DEST%" |
...
The value |
| Numeric Fields such as Quantity and Price | |
|---|---|
1000 | 1000 |
>1000 | Greater than 1000 |
>=1000 | Greater than or equal to |
...
| |
<1000 | Less than |
<= |
...
1000 | Less than or equal to |
...
|
!= |
...
1000 | Not equal to |
...
| |
1000-2000 | Between 1000 and 2000 |
!= |
...
1000-2000 | Not between |
1000,1500,2000 | 1000, 1500 or 2000 |
!=1000,2000 | Not 1000 or 2000 |