At 08:43 PM 3/29/00 +0200, you wrote:

>From: "Steve Tendon" <steve@...>
>
>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.
>

Why is this a problem?

>
>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...)
>

Uh, the point was to retrieve data preserving case but ordered
case insensitively. Your view returns everything in upper case.
And it can't use indexes for retrieval. And it can't be updated.
Other than that, there's not much wrong with it.

Jim Starkey