Received: from iolite.sge.net (iolite.sge.net [152.91.14.26]) by hub.org (8.10.1/8.10.1) with ESMTP id e5N36L140491 for ; Thu, 22 Jun 2000 23:06:22 -0400 (EDT) Received: from cadmium.sge.net (cadmium.sge.net [152.91.9.5]) by iolite.sge.net (Postfix) with ESMTP id ED99BBD08 for ; Fri, 23 Jun 2000 13:06:15 +1000 (EST) Received: (from uucp@localhost) by cadmium.sge.net (8.9.3/8.9.3) id NAA22399 for ; Fri, 23 Jun 2000 13:06:15 +1000 (EST) Received: from nodnsquery(10.1.2.11) by cadmium.sge.net via smap (V5.0) id xma022285; Fri, 23 Jun 00 13:06:07 +1000 Received: from amber (ice-int2.sge.net [10.1.2.254]) by kryptonite.sge.net (8.9.3/8.9.3) with SMTP id NAA04439 for ; Fri, 23 Jun 2000 13:06:07 +1000 (EST) Message-Id: X-Mailer: Novell GroupWise 5.2 Date: Fri, 23 Jun 2000 13:04:59 +1000 From: "Gary MacMinn" To: pgsql-sql@postgresql.org Subject: Merging two columns into one Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e5N36O140840 X-Archive-Number: 200006/199 Hi All, I have two columns in a table (areacode and phone number) that I'd like to merge into one (phone number) containing both sets of info. Could anyone suggest a simple way of achieving this? Thanks, Gary MacMinn