formatting numbers keeping the lead zero

[mieumieu]

I need to format interger variable such as 10, 20 into varchar such as 010, 020.
Do you have any suggestions?
Thanks

[ck9663]

declare @myIntVar int

set @myIntVar = 12

select  right('00000' + cast(@myIntVar as varchar(5)),5)

note:

This code is for a 5-digit number. Adjust the code as necessary.

-- CK