Siebel Personalization Administration Guide > Operators for Building Condition Expressions >

Pattern Matching Operators


Table 30 lists pattern matching operators.

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

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

Siebel Personalization Administration Guide Copyright © 2006, Oracle. All rights reserved.