Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Siebel Tools Fundamentals > Using Queries to List Object Definitions >

Simple Queries

---

A simple query finds information based on one condition. Table 8 lists the operators you can use to create a simple query.

Table 8. Simple Operators

Operator	Description
=	Equal to
<	Less than
>	Greater than
<>	Not equal to
<=	Less than or equal to
>=	Greater than or equal to
*	Any number of characters (including none) may take the place of the asterisk (*)
?	Any one character matches the question mark (?)
IS NOT NULL	Searches for non-blank fields
IS NULL	Searches for blank fields
LIKE	Searches for values starting with the indicated string
NOT LIKE	Searches for values not starting with the indicated string
" "	Searches for strings that contain special characters, such as a comma (,)
EXISTS ( )	Searches for values in a multi-value group
[~]	Forces the case of the text string to whatever follows the tilde

For more information on search specifications and operators and on Siebel data types, see Siebel Developer's Reference and Siebel Object Types Reference.

Bookshelf Home | Contents | Index | Search | PDF