Simple Oracle/sql statement concatenation query

From: Marc[uk] <marc_1974uk_at_hotmail.com>
Date: Mon, 7 May 2001 16:09:25 +0100
Message-ID: <989248242.27925.0.nnrp-07.c2decc6c@news.demon.co.uk>

Hi there,

I am trying to put an ASP site together using Dreamweaver Ultradev and i am connecting to an Oracle 8i (8.1.6) database from that fine.

However for one of the pages I am looking to add a string value to a select result.

at the moment the statement is:

SELECT NAME, NAME FROM PGSMAIN.PEOPLEDATA ORDER BY NAME ASC which works fine but I would like to add the string "@progression-uk.com" to each resulting name field.

I thought it would be something like SELECT NAME+'@progression-uk.com' AS EMAILNAME FROM PGSMAIN.PEOPLEDATA ORDER WHERE BY NAME ASC. but this returns no records.

can anyone help?

thanks,

Marc[uk] Received on Mon May 07 2001 - 10:09:25 CDT