On Tue, 2 Jan 2001, D. Duccini wrote:
>
> i think its time for afternoon coffee
>
> how do you select multiple columns but return them as a single column?
>
> ie, select lastname+', '+firstname as fullname from authors;
>
> of course it chokes on the + op
SELECT lastname || ', ' || firstname AS fullname FROM authors;