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

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 Whenever I use AS, I end up getting the SQL error "Two few parameters: x expected" where is

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

- 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...