UFN_SPONSORSHIPOPPORTUNITYDIMENSION_GETNAME

create function dbo.UFN_SPONSORSHIPOPPORTUNITYDIMENSION_GETNAME(@ID nvarchar(50)) returns nvarchar(50) 
as
begin
    declare @s nvarchar(50);
    if @ID in('Child age range',
              'Child disability/illness',
              'Child gender',
              'Project category')
              -- values get uppercased in database, want to display in user-friendly casing

        select @s = case @ID
                     when 'Child age range' then 'Child age range'
                     when 'Child disability/illness' then 'Child disability/illness'
                     when 'Child gender' then 'Child gender'
                     when 'Project category' then 'Project category' end;
    else
    select @s = 'Opportunity ' + DESCRIPTION from dbo.SPONSORSHIPLOCATIONTYPECODE where ID = @ID;

    return @s;
end