Bookshelf Home | Contents | Index | Search | PDF |
Siebel Developer's Reference > Operators, Expressions, and Conditions >
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:
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:
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 the following table.
Character is case-sensitive when executing pattern matching. In addition, the parentheses are required when including the NOT logical operator (the second variation of the NOT syntax).
NOTE: On occasion, using the wildcard * to find all entries in a field can cause a performance problem. If it does, use IS NOT NULL instead. For more information, see NULL.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Developer's Reference Published: 23 October 2003 |