Re: Is this a bug ?

On 10/23/19 11:20 AM, Geoff Winkless wrote:
> On Wed, 23 Oct 2019 at 17:09, Ron <ronljohnsonjr@gmail.com> wrote:
>
>> As much as I hate to say it, MSFT was right to ignore this bug in the standard.
> Standards are standards for a reason. It is almost never correct to
> deliberately ignore them. If you don't like them, then revise the
> standard.
>
> Historically Microsoft ignored standards either because they
> misunderstood them or because they wanted to lock in their customers,
> not for any reasons of altruism.
>
> For what it's worth, I can see a value to having
>
> SELECT 'this is quite a long string'
>                 'which I've joined together '
>                 'across multiple lines';
>
> although the advantage of it vs using a concat operator is slim.

It just occurred to me that this is probably something that COBOL does (it's 
been 30 years, so I might be mistaken) and so that's how it slipped into the 
SQL standard.

-- 
Angular momentum makes the world go 'round.