Bookshelf Home | Contents | Index | Search | 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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Search Administration Guide Published: 19 June 2003 |