A bit longer, but more obvious.

DECLARE @INTINT= 1 ;

SELECT REPLICATE('0', 2 - LEN(@INT)) + CAST(@INT AS VARCHAR)

Pass the column name instead of @INT