Re: [GENERAL] Concatenation in SELECT
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
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