From: Jim Starkey

>The current SQL "order by" clause is
>
> { <expr> | <position> } [ ASC | DESC ]
>
>We could make it
>
> { <expr> | <position> } [ ASC | DESC ] [CASE SENSITIVE | CASE INSENSITIVE]
>
>Obviously the default would "CASE SENSITIVE".

Can we use the "CASE" and "NOT CASE" syntax? It would be nice to add this
ability on the "create index" statement.

CREATE [UNIQUE] [CASE | NOT CASE] [ASC | DESC] INDEX on table (Column1)
or
CREATE [UNIQUE] [ASC | DESC] INDEX on table (Column1 [CASE | NOT CASE],
Column2)

Thanks,
Matt Larsen