Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA05317 for ; Thu, 3 Sep 1998 09:19:22 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Wed, 2 Sep 1981 08:13:17 -0400 Date: Thu, 3 Sep 1998 09:22:54 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Concatenation in selects Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Sep2.081317edt.35713@gateway.lee.k12.nc.us> I know it can be done, but I cannot seem to figure out how to output to fields concatenated together in a select. For instance, I have a table with first_name and last_name as fields (among others). I would like display first_name and last_name as one field. I want to do something like: name=first_name + " " + last_name but of course within an SQL select statement. Thanks...james