Siebel Customer Relationship Management Siebel Fundamentals Siebel Innovation Pack 2013, Version 8.1/8.2 E24770-01 |
|
Previous |
Next |
View PDF |
In Table 8-2, operators are shown in uppercase; however, query strings are case-sensitive, and the operators do not have to be in uppercase.
When you perform a compound query, you must use parentheses to control the order in which the search for matching records is performed.
Table 8-2 Compound Query Operators
Operator | Description | Example |
---|---|---|
AND, and |
Placed between values, returns only records for which all the given conditions are true. |
|
OR, or |
Placed between values, returns records for which at least one condition is true. |
|
NOT, not |
Placed before a value, returns only records that do not contain the value. |
|
() |
Surrounds the values and operators that will be processed first, regardless of the default processing order. |
|
LIKE, like |
Placed before a value, returns records containing the value. |
Note: The LIKE operator is case sensitive. To find matches regardless of case, see Table 8-1. |