Padding an string with a character (n times) in SQL Server

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