Siebel Personalization Administration Guide > Operators for Building Condition Expressions >
Comparison Operators
Table 28 lists comparison operators. See also Arithmetic Operators, Logical Operators, and Pattern Matching Operators.
Table 28. Comparison Operators
|
|
= |
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. |
|