UFN_SPONSORSHIPOPPORTUNITYRESERVATIONAGERANGE_GETNAME

create function dbo.UFN_SPONSORSHIPOPPORTUNITYRESERVATIONAGERANGE_GETNAME(@ID uniqueidentifier) returns nvarchar(10) 
as
begin
    declare @NAME nvarchar(10)
    if @ID = '626658D1-E24B-4370-952D-1080B22C33AE'
   begin
    set @NAME = 'Balanced'
   end
  else
   begin
    select @NAME = DISPLAYNAME
      from dbo.SPONSORSHIPOPPORTUNITYAGERANGE
      where ID = @ID;
   end
    return @NAME
end