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.