Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Search Administration Guide > Filter Search Specifications Syntax for Oracle Secure Enterprise Search > Filter Search Specification Syntax > Pattern Matching with LIKE and NOT LIKEThe LIKE operator is used in character string comparisons with pattern matching. char1 is the value to be compared with the pattern.
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 one of the following: 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 18. |
![]() ![]() |
Siebel Search Administration Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |