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