What are we cooking today?
Padding an string with a character (n times) in SQL Server
RECIPE
Declare @myString as varchar(10)
set @myString = '1234567'
select RIGHT(REPLICATE('0', 10)
+ CAST(@mystring AS VARCHAR(10)), 10) PaddedResult
RESULT:
0001234567