UFN_FAFREGISTRANTGROUP_BUILDNAME

create function dbo.UFN_FAFREGISTRANTGROUP_BUILDNAME(@ID uniqueidentifier) returns nvarchar(70) 
as
begin
    declare @s nvarchar(50) = '';
    select @s=case when TX.ID is not null and TFT.NAME <> C.NAME then TFT.NAME + ' (' + C.NAME +')' else C.NAME end
  from dbo.CONSTITUENT C (nolock)
  left join dbo.TEAMEXTENSION TX (nolock) on C.ID = TX.TEAMCONSTITUENTID
  left join dbo.TEAMFUNDRAISINGTEAM TFT (nolock) on TX.TEAMFUNDRAISINGTEAMID = TFT.ID
  where C.ID = @ID
    return @s;
end