|Bookshelf Home | Contents | Index | PDF|
By default, Siebel applications are case-sensitive. If you perform a query or search, there is a match only if the search criteria you enter are capitalized in the same way the data is capitalized in the database.
If you do not want queries and searches to be case-sensitive, you can enable case insensitivity either for the entire application or for selected fields. Regardless of which setting you choose, users can use operators to force case-sensitive or case-insensitive searches.
To force a case-sensitive search, use the operator = followed by the criterion in single quotation marks. For example, if the user enters the criterion
To force a case-insensitive search, use the operator ~LIKE. For example, if the user enters the criterion
|Applications Administration Guide|