Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Simple Oracle/sql statement concatenation query
Try select name || '@progression-uk.com' name from PGSMAIN.PEOPLEDATA
"Marc[uk]" <marc_1974uk_at_hotmail.com> wrote in message
news:989248242.27925.0.nnrp-07.c2decc6c_at_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 - 13:58:11 CDT