Bookshelf v7.5.3: Query Operators

Table 15 shows these commonly used query operators. For more query operators, see Query Operators.

CAUTION: Query operators are reserved in Siebel query language. If you create a query that has a query operator in it, you must put the query in double quotes. For example, running a query for records containing the text call is closed will fail. The word IS falls into the category of reserved Siebel query language, because it is used in the query operators IS NULL, IS NOT NULL, and so on. If you put "call is closed" in double quotes, the system will be able to return all records containing the text call is closed. Other reserved operators include apostrophe ('), comma (,), parentheses (()), double quotes (""), tilde (~), and comparison operators such as =, <, and >.

Table 15. Common Query Operators
Operator	Description	Example
=	Equal to	`=CA` retrieves all records in which the value in the query field is CA.
<	Less than	`<4/25/01` retrieves all records in which the value in the query field is before the given date.
>	Greater than	`>4/25/01` retrieves all records in which the value in the query field is after the given date.
<>	Not equal to	`<>CA` retrieves all records in which the state is not CA.
<=	Less than or equal to	`<=4/25/01` retrieves all records in which the value in the query field is on or before the given date.
>=	Greater than or equal to	`>=4/25/01` retrieves all records in which the value in the query field is on or after the given date.
*	Wildcard	`Sie*` retrieves any names that begin with the letters Sie. Wildcards can also be placed in the middle or at the beginning of a text string.
""	Double quotes	`"Siebel Systems"` retrieves all records that contain Siebel Systems in the query field. Text in double quotes, unless modified by a wildcard, must be matched exactly. If your query includes a blank space, you must enclose the query between double quotes or the space will be ignored.
~	Approximately	Placed before LIKE and a value with a wildcard operator, returns all matching records regardless of case. `~LIKE Smi` finds all records in which the value in the query field starts with Smi, smi, SMI*, and so on. Using this operator may affect performance.