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