Re: [SQL] combining columns in select

Thus spake Jens Glaser
> On Sat, 2 Oct 1999, Doug Thistlethwaite wrote:
> >    select lname + ', ' + fname as NAME from table ...
> 
> I think this is a parser bug. I recall there is a simple workaround:
> 
> select (lname + ', ') + fname ... (use braces)

While you are correct in your solution, it isn't a parser bug.  It just
follows the spec.  There has been talk of allowing the first form as
an extension.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.