Siebel Search Administration Guide > Syntax For Filter Search Specifications > Filter Search Spec Syntax >

Pattern Matching with LIKE and NOT LIKE

NOTE:  The Search Engine Table property for View and Applet must be based on the same table as the index. For example, if the search index is based on S_EVT_ACT, then the view should be based on action and the applet should be based on action. The LIKE operator is used in character string comparisons with pattern matching.

The syntax is as follows:

The syntax including the NOT logical operator is:

While the equal ( = ) operator does exact matching, the LIKE operator matches a portion of one character value to another. Patterns can use special characters to denote different characters. These characters are given in Table 35.

Table 35. Pattern Matching Using Special Characters
Zero or more characters
[Sales Type] LIKE Sales* would return all records whose [Sales Type] value starts with the characters Sales, as in Sales-Brochure, Sales-Presentation, and so on.
One character
[Sales Type] NOT LIKE Sale? would return all records whose [Sales Type] value was 5 characters long and did not start with the letters Sales. Records with Sales would not.

 Siebel Search Administration Guide, Version 7.5, Rev A 
 Published: 18 April 2003