Thank Borislav, Here is the corrected version for the benefit of other.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE FUNCTION [dbo].[fncPayeeTypeList] (
@PayeesFK as INT
)
RETURNS varchar(Max)
as
begin
DECLARE @PayeeType as varchar(Max)
Select @PayeeType = ISNULL(@PayeeType + char(10), '') + GEN_PayeeTypes.PayeeType FROM GEN_PayeeTypes
left Join
GEN_PayeeTypeLink
on GEN_PayeeTypeLink.PayeeTypeFK = GEN_PayeeTypes.PayeeTypePK
WHERE GEN_PayeeTypeLink.PayeesFK = @PayeesFK
RETURN @PayeeType
end
