create function dbo.formati(@value int, @pad int, @padchar char(1) )
returns varchar(max)
as
begin
	return (select REPLICATE( @padchar ,@pad-len(@value)) + convert(varchar,@value) )
end
go

create function dbo.formatd(@value decimal(10,2), @pad int, @padchar char(1) )
returns varchar(max)
as
begin
	return (select REPLICATE( @padchar ,@pad-len(@value)) + convert(varchar,@value) )
end
go

select dbo.formati( MONTH('2008-09-01'),2, '0' )
select dbo.formati( 123,5, '0' )
select dbo.formatd( 123.45,8, 'x' )