Re: Columns join help?

From: Martin Jarvis <smj_at_jbecpor.demon.co.uk>
Date: Mon, 8 Feb 1993 10:04:21 +0000
Message-ID: <C24Jz9.HKK_at_jbecpor.demon.co.uk>

If you just want to concatenate the columns together use :-

select col1 || ' ' || col2 || ' ' || col3 from whatever

the || is the concat operator.

Regards,

Martin

---

   Martin Jarvis                         |    John Brown E & C Ltd,
   smj_at_jbecpor.demon.co.uk               |    1 Buckingham Street, 

   Martin Jarvis /JBEC-Portsmouth, IT | Portsmouth, Hampshire, UK

---

Received on Mon Feb 08 1993 - 11:04:21 CET