If I've understood what you mean, the answer is:
"select 'Hello ' || name from user"
( || is pipe character two times )
Bye
Roberto
----- Original Message -----
From: "Ricky" <ricky@babonmultimedia.com>
To: <pgsql-odbc@postgresql.org>
Sent: Thursday, December 18, 2003 11:44 AM
Subject: Re: [ODBC] add some word in select
> 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 row name
>
> thanks
> RIcky
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend