Pad Number

CREATE FUNCTION padNumber (@theString varchar(255), @padSize int, @padChar char(1))
RETURNS char(50)
AS
BEGIN
-- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
--      Script by Daniel Field, daniel@worldof.net 2003
-- =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+	declare 
		@theResult	char(50),
		@count		int,
		@c		int

	set @count = Len(RTrim(@theString) )
	set @c = 0	

	if @count > @padSize
	begin
		set @theResult = RTrim( @theString )
	end
	else
	begin
		set @theResult = Replace(SPACE(@padSize-@count) + RTrim( @theString ), ' ', @padChar)
	end
	set @theResult = replace(@theResult, ' ', '0')

	return @theResult
END