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>
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 DykstraReceived on Tue Feb 05 2008 - 17:43:31 CST