IF OBJECT_ID (N'dbo.ddf_CommaSeparatedPOs') IS NOT NULL
DROP FUNCTION dbo.ddf_CommaSeparatedPOs
GO
CREATE FUNCTION dbo.ddf_CommaSeparatedPOs (@vendorid varchar(15), @docnumbr varchar(21))
-- select dbo.ddf_CommaSeparatedPOs('ASSOCIAT0001','445')
RETURNS varchar(max)
AS
BEGIN
declare @PO as varchar(max)
select distinct @PO = coalesce(@PO + ',','') + rtrim(rl.PONUMBER)
from pop30300 rh
join pop30310 rl on rl.POPRCTNM = rh.POPRCTNM
where rh.VENDORID = @vendorid and rh.VNDDOCNM = @docnumbr
return @PO
END
GO