select right('00000'+@s,6)

declare @s varchar(10) 
set @s='32' 
select right('00000'+@s,6),right(replicate('0',6)+@s,6)

declare @n int
set @n='32' 
select right(100000+@n,5)

/*

----------
00032

(1 row(s) affected)
*/

select right(100000+32,5), right(100000+126,5)

/*

---------- ----------
00032      00126

(1 row(s) affected)
*/