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.

This table shows which operators to use to force case-sensitive 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.
CIAI	`~` followed by other operators if required, and the criterion.	`~LIKE computer` returns all records that have computer in the field, regardless of capitalization. `~LIKE francais` returns all records that have francais in the field, regardless of capitalization or accent.

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.