> >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?
>

Not really, if we can live with a double meaning.

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

OK. That changes the matter. Probably Dave's collation driver is the
cleanest solution then.

> Other than that, there's not much wrong with it.
>

:-)

-ST