Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Simple Oracle/sql statement concatenation query

Re: Simple Oracle/sql statement concatenation query

From: Dave Fowler <d.fowler_at_smmj.com>
Date: Mon, 07 May 2001 18:58:11 GMT
Message-ID: <7fCJ6.1039$Y23.92746@newsread2.prod.itd.earthlink.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US