I have a table with a column of numbers like
789. I want to pad them with 0 to equal 9 digits. For example,
789 should be
I have tried this code, but there are some numbers more than 3 digits and less than 3 digits.
UPDATE Table SET MyCol = MyCol+'0000000' WHERE LEN(MyCol) >9;