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>
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