UFN_RE7MEMBERSHIPRENEWAL_GETNAMEONRENEWAL

create function dbo.UFN_RE7MEMBERSHIPRENEWAL_GETNAMEONRENEWAL(@ID int)
returns  nvarchar(400)
as
begin
  return (select
        case when isnull([MR].[NAMEONRENEWAL], '') = '' then [C].[FULLNAME] + ' - ' + case [MR].[SENTTOCODE_LOCALID] when 0 then 'Donor' when 1 then 'Primary member' when 2 then 'Both' end
        else [C].[FULLNAME] + ' - ' + case [MR].[SENTTOCODE_LOCALID] when 0 then 'Donor' when 1 then 'Primary member' when 2 then 'Both' end + ' - ' + [MR].[NAMEONRENEWAL] end [IDENTIFIER]
        from [dbo].[RE7_MEMBERSHIPRENEWAL] [MR]
        left outer join dbo.[RE7_CONSTITUENTMEMBERSHIP] [CM] on [MR].[TRANSACTION_LOCALID] = [CM].[LOCALID]
        left outer join dbo.[RE7_CONSTITUENT] [C] on [CM].[CONSTITUENT_LOCALID] = [C].[LOCALID]
        where [MR].[LOCALID] = @ID)
end