CaseSens and CaseInsens

The CaseSens keyword can be used in OpenList queries to force a case-sensitive search of data. The CaseInsens keyword can be used in queries to force a case-insensitive search of data. These keywords can be used against indexed or non-indexed tables and columns to override the existing case sensitivity for queries defined in the environment.

With [Every] [CaseSens | CaseInsens] COLUMN comparison [value]

- OR -

Limit [CaseSens] COLUMN comparison [CaseInsens] range

Use the CaseSens keyword with any one of the selection keywords below to override the query case insensitivity in the user environment (Options-Configuration-Environment-Query-Query Processes from the Opening menu). This keyword will have no effect if the user environment setting is already case-sensitive.

Use the CaseInsens keyword with any one of the selection keywords below to override the case sensitivity setting, if case-sensitive search is defined in the user environment.

Note: For information about the general syntax of Limit and With clauses, refer to those keywords elsewhere in this chapter.

Lists all customers in a table with the name "Smith". The customer names "SMITH" and "smith" will not be included in the report.

List CUSTOMERS With CaseSens LAST_NAME = "Smith"

Lists all customers in a table with the name Smith, regardless of the case of the data. The customer names "Smith", "SMITH", and "smith" will be included in the report.

List CUSTOMERS With CaseInsens LAST_NAME = "Smith"