Advanced Search | Top Previous Next

This chapter contains information about the advanced search operators you can use in the application GUI fields. The following Table lists operators allowed in QueWeb and to which data types they apply:
Operator (Meaning) | String | Date | Number
> (Greater Than) | + | + | +
< (Less Than) | + | + | +
>= (Greater Or Equal Than) | + | + | +
<= Less Or Equal Than | + | + | +
! (Not Equal) | + | + | +
= (Exact Match) | + |  |
& (Logical AND) | + | + | +
| (Logical OR) | + | + | +
.. (Date Interval) |  | + |
^nnn (search string must start with nnn ) | + |  |
$ (search results must end with nnn) | + |  |
+ (Math Plus) |  | + |
- (Math Minus) |  |  |
* (Substitute any characters) | + |  |
? (Substitute any number of characters; each ? represents one character) | + |  |
@ (Case Insensitive) | + |  |
You can set one of the following Date formats for your account: Note: Modificators used in table:
• | d= DAY
• | M=Month
• | y=Year
Format | Examples | Format | Examples
d MMM yy | 4 Jan 96 24 Jan 96 | MM/dd/yy | 01/04/96 12/24/96
d MMM yyyy | 4 Jan 1996 24 Jan 1996 | MM/dd/yyyy | 01/04/1996 12/24/1996
dd MMM yy | 04 Jan 96 24 Jan 96 | MMddyy | 010496 122496
dd MMM yyyy | 04 Jan 1996 24 Jan 1996 | MMddyyyy | 01041996 12241996
dd/MM/yy | 01/04/96 21/24/96 | MMM d, yyyy | Jan 1, 1996 Jan 24, 1996
ddMMMyy | 04Jan96 24Jan96 | MMMM d yy | January 1 96 January 24 96
ddMMMyyyy | 04Jan1996 24Jan1996 | MMMM d yyyy | January 4 1996 January 24 1996
dMMMyy | 4Jan96 24Jan96 | MMMM dd yy | January 04 96 January 24 96
M/d/yy | 1/4/96 12/24/96 | MMMM dd yyyy | January 04 1996 January 24 1996
M/d/yyyy | 1/4/1996 12/24/1996 |  |
Note: If you want to search for a reserved symbol used as an Operator then this symbol has to be enclosed in backslashes: ‘\’. For example, a user needs records with ‘AT&T’ in the name field. In this case he or she would have to type ‘AT\&\T’ in the name field.