UFN_DESIGNATIONLEVELRECIPIENT_GETRECIPIENTNAME

create function dbo.UFN_DESIGNATIONLEVELRECIPIENT_GETRECIPIENTNAME(@ID uniqueidentifier)
returns nvarchar(700)
as begin
    if @ID is null
        return '';

    return (
    select NF.NAME
    from 
      dbo.DESIGNATIONLEVELRECIPIENT
      cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(DESIGNATIONLEVELRECIPIENT.CONSTITUENTID) NF 
    where
      DESIGNATIONLEVELRECIPIENT.ID = @ID
  );
end