----- Original Message -----
From: "Bowyer, Alex" <[EMAIL PROTECTED]>
> 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
[EMAIL PROTECTED] ICQ will yield no hits IT Systems & Services
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )