Siebel Applications Administration Guide > Ongoing Application Administration Tasks > About Case-Insensitive and Accent-Insensitive Queries and Searches >

Forcing Case-Sensitive or CIAI Queries or Searches


Regardless of the setting for case-sensitive and accent-sensitive queries, users can use operators to force case-sensitive or CIAI queries or searches. The following table describes the operators to use to force case-sensitive or CIAI queries or searches:

Type of Query
Operator
Examples

Case sensitive and accent sensitive

= followed by the criterion in single quotation marks

='Computer' returns only records that have Computer spelled with a capital C.

In searches with complex criteria, the user must also use the tilde (~) operator to force the CIAI feature, regardless of the setting for case-sensitive and accent-sensitive queries and searches.

Siebel Applications Administration Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.