Simple Query Operators

The following table describes the operators that you can use to create a simple query. A simple query is a type of query that locates records according to one condition. A check mark in a property that can contain a Boolean value represents TRUE. The Changed property is an example of a property that contains a Boolean value. For more information about query operators and Siebel data types, see Siebel Developer's Reference.

Operator	Description
=	Equal to (equals operator).
<	Less than (opening angle bracket).
>	Greater than (closing angle bracket).
<>	Not equal to (opening angle bracket and closing angle bracket).
<=	Less than or equal to (opening angle bracket and equals operator).
>=	Greater than or equal to (closing angle bracket and equals operator).
*	A wildcard. An asterisk (*) can represent any number of characters, including no characters.
?	A wildcard. A question mark (?) can represent any single character.
IS NOT NULL	Queries for a property that is not empty.
IS NULL	Queries for an empty property.
LIKE	Queries for a value that begins with the string that you enter.
NOT LIKE	Queries for a value that does not start with the string that you enter.
" "	Queries for a string that includes a special character. For example, enter "MyQuery's Text" to query for the MyQuery’s Text string. If your query text includes a special character, then use quotes to enclose the query.
EXISTS()	Queries for a value in a multi-value group.
~	Forces the text string to use the case that follows the tilde (~).