Re: [GENERAL] Concatenation in SELECT

2003-11-21 Thread Manfred Koizar
On Fri, 21 Nov 2003 20:22:17 +0900, Alex <[EMAIL PROTECTED]> wrote: >Hi, >is it possible to concatenate two rows (same or different data type) >into one. >like First Name, Last Name or ZIP City etc. If you meant to concatenate two *columns*, it goes like SELECT firstname || ' ' || las

[GENERAL] Concatenation in SELECT

2003-11-21 Thread Alex
Hi, is it possible to concatenate two rows (same or different data type) into one. like First Name, Last Name or ZIP City etc. Thanks Alex ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster