The CASE keyword causes Zen 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’, then a query with a restriction specifying Name = ‘smith’ correctly returns both rows.
Note CASE (string) does not support multiple-byte character strings and NCHAR strings. The keyword assumes that the string data is single-byte ASCII. This means that the CASE attribute is not supported for NVARCHAR and NCHAR data type columns. The string functions do support multiple-byte character strings and NCHAR strings. See String Functions.
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 use CASE in an ORDER BY clause of a SELECT statement.
SELECT Id, Last_Name+', '+First_Name AS Whole_Name, Phone FROM Person ORDER BY Whole_Name CASE