Siebel Personalization Administration Guide > Operators for Building Condition Expressions >

Comparison Operators


Table 30 lists comparison operators.

See also Arithmetic Operators, Logical Operators, and Pattern Matching Operators.

Table 30.  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