IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'ddf_PadRight')
DROP FUNCTION ddf_PadRight
GO
CREATE FUNCTION ddf_PadRight (@input as varchar(max),@length as int, @padchar as varchar(1))
-- select dbo.ddf_PadRight('test',9,'x')
Returns varchar(max)
AS
begin
declare @output as varchar(max)
set @output = left(@input,@length)
set @output = left(@output + REPLICATE(@padchar,@length),@length)
return (@output)
end