Siebel Personalization Administration Guide > Siebel Query Language > Operators >

Comparison Operators

Operator
Description
=
Equal to a specific value.
<>
Not equal to a specific value.
>
Greater than a specific value.
<
Less than a specific value.
>=
Greater than or equal to a specific value.
<=
Less than or equal to a specific value.
~
NOT. Used to exclude values.
IS NULL
Finds blank fields.
Using the = operator without any accompanying value does not give you the same results as IS NULL.
IS NOT NULL
Finds non-blank fields.


 Siebel Personalization Administration Guide 
 Published: 18 April 2003