FWIW: Is everybody aware that "CASE" is standard SQL keyword (currently not
supported by IB) used like a "switch" in C or "case" in Pascal.

Unless we want operator overloading too... I suggest finding an alternative
word in place of "CASE" to mean upper/lowercase sensitive/insensitvie
comparisions.

OTOH, do we really need this? Can't we get what you want with a view and a
UDF. With some shorthand here:

create table t(f1, f2);

create view ut(f1, f1) as select ucase(f1), ucase(f2) from t;

select f1, f2 from ut order by f1

Case solved. (Pun intended...)

-ST

----- Original Message -----
From: "Matt Larsen" <mlarsen@...>
To: <IB-Architect@onelist.com>
Sent: Wednesday, March 29, 2000 6:59 PM
Subject: RE: [IB-Architect] Syntax for case insensitive sort


> From: "Matt Larsen" <mlarsen@...>
>
> 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
>
>
> ------------------------------------------------------------------------
> Good friends, school spirit, hair-dos you'd like to forget.
> Classmates.com has them all. And with 4.4 million alumni already
> registered, there's a good chance you'll find your friends here:
> http://click.egroups.com/1/2622/3/_/_/_/954349041/
> ------------------------------------------------------------------------
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>