Re: table update question

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

"shadow" <> wrote in message news:47a8eaed$0$26143$
> 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