Re: table update question

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Tue, 05 Feb 2008 23:43:31 GMT
Message-ID: <Dw6qj.5829$cc3.1702@edtnps82>


"shadow" <NOSSPAM_at_gmail.com> wrote in message news:47a8eaed$0$26143$5fc30a8_at_news.tiscali.it...
> hi all,
> i have an easy (sure for you) question related to a data modification in
> one column of a "codice" table, i'd like to add a prefix (alwais the same
> ... something like AX) to the exixting data in the table
> what is the easyest way to do it?
> thanks a lot and best regards
> Paolo
> ps: i tried to search in google but i didn't find (or better i didn't
> see ) this info

If I understand your question correctly, it could be as simple as:

update codicetable
set mycolumn = 'AX' || mycolumn
/

-- 
Terry Dykstra 
Received on Tue Feb 05 2008 - 17:43:31 CST

Original text of this message