Table 2. Search Query Examples
Operator
|
Query Type
|
Query Example
|
Separate Terms With
|
Returns All Records and Documents That:
|
AND
|
AND query
|
performance AND memory
|
N/A
|
Contain both performance and memory
|
&
|
AND query
|
performance & memory
|
N/A
|
Contain both performance and memory
|
OR
|
OR query
|
performance OR memory
|
N/A
|
Contain either performance or memory
|
|
|
OR query
|
performance | memory
|
N/A
|
Contain either performance or memory
|
""
|
Phrase query
|
"memory performance"
|
N/A
|
Contain the entire phrase, memory performance
|
|
|
memory performance
|
AND
|
Contain both performance and memory
|
|
|
memory performance
|
OR
|
Contain either performance or memory
|
"" ""
|
Multiple phrases
|
"Microsoft Windows" "Sun Solaris"
|
AND
|
Contain both Microsoft Windows and Sun Solaris
|
"" ""
|
Multiple phrases
|
"Microsoft Windows" "Sun Solaris"
|
OR
|
Contain either Microsoft Windows or Sun Solaris
|
?
|
Wildcard
|
operate?
|
N/A
|
Contain operates or operated, but not operate
|
?
|
Wildcard
|
?rag
|
N/A
|
Contain brag, crag, drag, or frag
|
*
|
Wildcard
|
*rang*
|
N/A
|
Contain any of arrange, arranged, arranges, arranging, orange, orangutan, range, ranges, ranging, rang, sprang, strange, stranger, strangest, strangle, wrangle, and so on.
|
( )
|
Grouping
|
(word OR excel) AND NOT microsoft
|
N/A
|
Contain either word or excel but do not contain microsoft
|
( )
|
Grouping
|
(word OR excel) NOT microsoft
|
N/A
|
(Error)
|
( )
|
Grouping
|
word OR (excel AND NOT microsoft)
|
N/A
|
Either contain word, or contain excel and have no reference to microsoft (microsoft may appear in the same document as word, but not in the same document as excel)
|
|
Multiple search terms
|
word OR excel NOT microsoft
|
N/A
|
Contain anything (finds all records and documents)
|
|
Multiple search terms
|
word OR excel AND NOT microsoft
|
N/A
|
Contain either word or excel but do not contain microsoft
|
NEAR
|
Proximity
|
log* NEAR performance
|
N/A
|
Contain any form of the word log within n characters of performance, where n is the number set in the Near Means field of the Options area of the Siebel Search Contents dialog box (Advanced Search only)
|