Bookshelf Home | Contents | Index | PDF     

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:

  • char1 LIKE char2

    where char1 is the value to be compared with the pattern and char2 is the pattern to which char1 is compared. The NOT logical operator can be used in conjunction with LIKE to exclude patterns.

The syntax including the NOT logical operator is:

  • char1 NOT LIKE char2

    or

  • NOT (char1 LIKE char2)

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
Character
Purpose
Example

*

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