SQL BASIC

 

DECLARE @parInt int  =  22

select FORMAT(@parInt,'0000000')

declare @parString nvarchar(20) = '22'

select format( cast(@parString as int),'000000')