Applications Administration Guide > Ongoing Application Administration Tasks >

About Case Sensitivity

By default, Siebel applications are case sensitive. If you perform a query or search, there will be a match only if the search criteria you enter are capitalized in the same way the data is capitalized in the database.

For important information about how case sensitivity affects performance, see Performance Tuning Guide.

To force a case-sensitive search, use the operator = followed by the criterion in quotation marks. For example, if the user enters the criterion ='Computer', the query will return only records that have "Computer" spelled with a capital C in the field.

To force a case-insensitive search, use the operator ~LIKE. For example, if the user enters the criterion ~LIKE computer, the query will return all records that have "computer" in the field, regardless of capitalization.

The user must also use ~LIKE to force case insensitivity in searches with complex criteria, regardless of the setting for case sensitivity.

NOTE:  You should determine your requirements for case-insensitive searching and set the appropriate parameters for the application or individual field before users enter any data.


 Applications Administration Guide
 Published: 09 September 2004