Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Steve Tendon
> >FWIW: Is everybody aware that "CASE" is standard SQL keyword (currently
> >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.