How do we add the truncated digit to the column values in SQL?

For example the column name is digits and it has values as

The length of column digit should be 4 and the last digit truncated was 0.
I have to add the 0 to all the truncated values.
So that the column digit should have values as after adding 0 in the end.

>Solution :

If you want to append a random digit to all the values in column Digits, you could do :

UPDATE TblName SET Digits = CAST(CAST(Digits AS VARCHAR) + '0' AS INT)

And you can replace ‘0’ with whatever digit you want to append?