IF OBJECT_ID (N'dbo.ddf_CommaSeparatedReceipts') IS NOT NULL
DROP FUNCTION dbo.ddf_CommaSeparatedReceipts
GO
CREATE FUNCTION dbo.ddf_CommaSeparatedReceipts (@vendorid varchar(15), @docnumbr varchar(21))
RETURNS varchar(max)
AS
BEGIN
declare @Receipt as varchar(max)
select @Receipt = coalesce(@Receipt + ',','') + rtrim(poprctnm)
from pop30300 rh
where rh.VENDORID = @vendorid and rh.VNDDOCNM = @docnumbr
return @Receipt
END
GO