tsql - How do I convert an int to a zero padded string in T-SQL?

Question

Let's say I have an int with the value of 1. How can I convert that int to a zero padded string, such as 00000001?

Answer 1

Declare @MyInt integer Set @MyInt = 123
Declare @StrLen TinyInt Set @StrLen = 8

Select Replace(Str(@MyInt, @StrLen), ' ' , '0')