Concatenation in selects

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Concatenation in selects
Date: 1998-09-03 13:22:54
Message-ID: 81Sep2.081317edt.35713@gateway.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message James Olin Oden 1998-09-03 14:16:33 Re: [SQL] Concatenation in selects
Previous Message Fidelis Assis 1998-09-03 12:17:43 Resp: [SQL] Concatenation in selects