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 
@theResultchar(50),
@countint,
@cint

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