Received: from druid.net (root@druid.net [216.126.72.98]) by hub.org (8.10.1/8.10.1) with ESMTP id e5NBeh190101 for ; Fri, 23 Jun 2000 07:40:43 -0400 (EDT) Received: from localhost (1201 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Fri, 23 Jun 2000 07:40:25 -0400 (EDT) (Smail-3.2.0.109 1999-Oct-27 #1 built 1999-Dec-25) Message-Id: From: darcy@druid.net (D'Arcy J.M. Cain) Subject: Re: Merging two columns into one In-Reply-To: <200006230553.e5N5rde14918@linda.lfix.co.uk> "from Oliver Elphick at Jun 23, 2000 06:53:37 am" To: Oliver Elphick Date: Fri, 23 Jun 2000 07:40:25 -0400 (EDT) CC: Christopher Sawtell , Gary MacMinn , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL78 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200006/205 Thus spake Oliver Elphick > SELECT col1, col2,..., areacode || phone as phone, colx, coly,... Although you may want this for easier reading. SELECT col1, col2,..., (areacode || ' ') || phone as phone, colx, coly,... Also, I would do "as fullphone" instead so that I don't get confused between the field name and my generated string but that's mainly a style issue. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.