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 KAA11400 for ; Thu, 3 Sep 1998 10:13:13 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Wed, 2 Sep 1981 09:07:02 -0400 Date: Thu, 3 Sep 1998 10:16:33 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] Concatenation in selects References: <81Sep2.081317edt.35713@gateway.lee.k12.nc.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Sep2.090702edt.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 Sorry, I finally found it in the hackers mailing list. The answer is: select textcat(textcat(first_name, ' '),last_name) from users; I just couldn't seem to find that documented, I am sure it is though. Thanks...james