Re: add some word in select

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(at)babonmultimedia(dot)com>
To: <pgsql-odbc(at)postgresql(dot)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