help - add a zero to the end of all prexisting values in a specific column

[agallo]

First, thanks in advance for any help provided in finding this solution.

 

I have been searching for the right string for a day now with no luck. I am trying to add a zero to the end of prexisting values, in all rows, and in a specific column. Any help as to the right query or pointing me in the right direction is much appreciated.

 

[Mchl]

Are they numeric or strings?

 

For numeric

UPDATE table SET field = field * 10;

 

For strings

UPDATE table SET field = CONCAT(field,'0');

[agallo]

perfect! thank you so much for the help