Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Ann Harrison
> >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.
> >

At 02:13 PM 3/29/00 -0500, Jim Starkey wrote:

>Why is this a problem?

This is a problem because SQL keywords have exactly one meaning. None
of this syntax sensitive semantic nonsense for SQL. If CASE is a
keyword for a function returning a value, then CASE can not be a qualifier
on something else, even if there is absolutely no chance of confusion.