Thread: add some word in select

add some word in select

From
"Ricky"
Date:
hello, i have sql "select name from user" then row result "John" come up. is
it posible that the result produce
"HELLO John"  . there's word "Hello" before the name

thanks
RIcky


Re: add some word in select

From
Stephen Powell
Date:
On Wed, 17 Dec 2003, ricky@babonmultimedia.com wrote:

> hello, i have sql "select name from user" then row result "John"
> come up. is it posible that the result produce "HELLO John" .
> there's word "Hello" before the name

Use the concatenation operator '||'.

select 'Hello ' || name from user where name = 'John';

You should probably download a copy of the user manual from
<http://www.postgresql.org/docs/> . It describes many of the functions
and operators that are available.

--
Stephen Powell