UFN_SPONSORSHIPREASONBULKTRANSFER_GETNAME

create function dbo.UFN_SPONSORSHIPREASONBULKTRANSFER_GETNAME(@ID uniqueidentifier) returns nvarchar(100) 
as
begin
    declare @s nvarchar(50);
  select @s = case REASONTYPECODE when 1 then 'Child - ' + REASON
                            when 2 then 'Project - ' + REASON
                            when 4 then 'Location - ' + REASON
                            when 5 then 'Transfer - ' + REASON
                  end 
  from dbo.SPONSORSHIPREASON where ID = @ID;
    return @s;
end