Sql format string – store procedure

declare @str varchar(12), @i int
set @str = ‘test1′
set @i = len(@str)

while(@i<10)
begin
 set @str = ‘0′ + @str
 set @i = @i + 1
end

select @str