Re: displaying 2 columns as 1

From: Mark <markg_at_mymail.co.uk>
Date: 16 May 2002 04:47:42 -0700
Message-ID: <ddb31653.0205160347.78d45cf9_at_posting.google.com>


You just answered your own question ;-)

SELECT first_name ||' '|| surname name
FROM table;

M

meads58_at_yahoo.co.nz (Meads) wrote in message news:<8054a75b.0205152243.3fca9b12_at_posting.google.com>...
> Hello I am trying to combine 2 text fields (firstName and SurName)
> to be displayed as one text field. I think I have have to write a
> select statement and concatenate it there?
Received on Thu May 16 2002 - 13:47:42 CEST

Original text of this message