Re: table update question
Date: Tue, 05 Feb 2008 23:43:31 GMT
"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
> 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:
set mycolumn = 'AX' || mycolumn
-- Terry DykstraReceived on Tue Feb 05 2008 - 17:43:31 CST