CASE

---

Remarks

The CASE keyword causes Pervasive.SQL to ignore case when evaluating restriction clauses involving a string column.

For example, suppose if 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.

Examples

The following example shows how you add a column to the Student table with the CASE keyword.

ALTER TABLE Student ADD Name char(64) CASE 

The following example shows how to modify a column with the CASE keyword.

ALTER TABLE Student MODIFY Name char(64) CASE 

See Also

ALTER TABLE

SELECT