The CASE keyword causes Pervasive PSQL to ignore case when evaluating restriction clauses involving a string column. CASE can be specified as a column attribute in a CREATE TABLE or ALTER TABLE statement, or in an ORDER BY clause of a SELECT statement.
For example, suppose you have a column called Name that is defined with the CASE attribute. If you insert two rows with Name = ‘Smith’ and Name = ‘SMITH,’ a query with a restriction specifying Name = ‘smith’ correctly returns both rows.