Subject | Re: [IB-Architect] Syntax for case insensitive sort |
---|---|
Author | Ann Harrison |
Post date | 2000-03-29T21:19:52Z |
> >From: "Steve Tendon" <steve@...>At 02:13 PM 3/29/00 -0500, Jim Starkey wrote:
> >
> >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?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.
Ann