LIKE and NOT LIKE Operators

The LIKE operator matches a portion of one character value to another value. Siebel CRM uses the following format for a LIKE operator in a character string comparison that uses pattern matching:

char1 LIKE char2

where:

• char1 is the value that Siebel CRM compares to the pattern.

• char2 is the pattern where Siebel CRM compares char1.

To exclude a pattern, you can use the NOT logical operator with the LIKE operator. It uses the following format:

char1 NOT LIKE char2 

or

NOT (char1 LIKE char2)

Each character is case-sensitive.

The NOT operator requires parentheses.

The Search Engine Table property of a view or applet must reference the same table that the index references. For example, if the search index references the S_EVT_ACT table, then the view and the applet must reference the Action business component.