[Zope] "SELECT ... AS ..." statement in ZSQL

[Dario Lopez-Kästen]

----- Original Message -----
From: "Bowyer, Alex" <BowyerA@logica.com>
> A simple question, but I can't seem to find a simple answer in any of the
> documentation...
>
> How do you do a SELECT AS statement in a ZSQL method?
>
> For example
> SELECT FirstName + " " + LastName AS FullName
>

hmm... shouldn't that be

    SELECT FirstName || " " || LastName as FullName

I am bit unsure of the proper syntax (I am mostly working with Oracle), but
I think you use "||" to concatenate two strings in SQL.

/dario
- --------------------------------------------------------------------
Dario Lopez-Kästen     Systems Developer  Chalmers Univ. of Technology
dario@ita.chalmers.se  ICQ will yield no hits    IT Systems & Services