I have created a numeric field which I would like to replace with the value of a character field. The character field should have been initially created as numeric and contains only numeric values.

So, basically, I need something like this:

UPDATE Client SET Amount2=Amount

But, as is, it will not work as a conversion has to be done. It is that part that I cannot find the proper syntax.

Amount2 is used as a temporary place holder. Once the update completed, the Amount field will go and Amount2 will be renamed Amount.