permanently zero pad a number
I am trying to zero pad a number with 10 zeros. The code below does what I want, but I can not update the table permanently. How can I do this? Thanks for any help!!!
SELECT Paddednumber =RIGHT(REPLICATE('0',10)+CAST(Number ASVARCHAR(10)),10)