UFN_CREDIT_GETPAYMENTMETHODLIST

CREATE function dbo.UFN_CREDIT_GETPAYMENTMETHODLIST
(
    @CREDITID uniqueidentifier
)
returns nvarchar(max)
with execute as caller
as begin
    declare @LIST nvarchar(max) = null;

    select
        @LIST = coalesce(@LIST, '') + 
                    case CREDITPAYMENT.PAYMENTMETHODCODE
                        when 10 then
                            coalesce(
                                case 
                                    when @LIST like '%' + OTHERPAYMENTMETHODCODE.DESCRIPTION + '%' then null
                                    else OTHERPAYMENTMETHODCODE.DESCRIPTION
                                end + ', ', ''
                            )                        
                        else 
                            coalesce(
                                case 
                                    when @LIST like '%' + CREDITPAYMENT.PAYMENTMETHOD + '%' then null
                                    else CREDITPAYMENT.PAYMENTMETHOD
                                end + ', ', ''
                            )                    
                    end
    from dbo.CREDITPAYMENT
    left outer join dbo.OTHERPAYMENTMETHODCODE
        on CREDITPAYMENT.OTHERPAYMENTMETHODCODEID = OTHERPAYMENTMETHODCODE.ID
    where CREDITPAYMENT.CREDITID = @CREDITID;

    if (@LIST like '%, ')
        set @LIST = substring(@LIST, 0, len(@LIST));

    return @LIST;
end