8Operators for Building Condition Expressions

Operators for Building Condition Expressions

This section describes the operators that are available for building condition expressions specific to Siebel Personalization. It includes the following topics.

• Arithmetic Operators

• Comparison Operators

• Logical Operators

• Pattern Matching Operators

For more information on operators, see Using Siebel Tools.

Arithmetic Operators

The following table lists arithmetic operators.

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

Operator	Description
+	Add
–	Subtract
*	Multiply
/	Divide
^	Power

Comparison Operators

The following table lists comparison operators.

See also Arithmetic Operators, Logical Operators, and Pattern Matching 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.

Logical Operators

The following table lists logical operators.

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

Operator	Description
AND	All conditions connected by AND must be TRUE.
OR	At least one condition connected by OR must be TRUE.
NOT	The condition modified by NOT must be FALSE.

Pattern Matching Operators

The following table lists pattern matching operators.

See also Arithmetic Operators, Comparison Operators, and Logical Operators.

Operator	Description
*	(asterisk) Wildcard for any number of characters before or after the value entered. Used in combination with LIKE.
?	(question mark) Wildcard for a single character. Used in combination with LIKE.
LIKE	Combine with a string and one or more wildcard characters to find all values with string. For example: [Product Line] LIKE *enti?m* returns records where the Product Line field contains the string enti?m such as The Pentium I Line and Pentiums.
NOT LIKE	Combine with a string and one or more wildcard characters to find all values without string.
EXISTS	Finds a value from a multivalue group. EXISTS also finds values in any child of the MVG. For example: EXISTS ([Product Component] = 4 Meg Ram) returns records in which attribute Product Component (an MVG) referred to is a child record with the value 4 Meg Ram.