UFN_EVENTREGISTRANTBATCH_EVENTREGISTRANTATTENDED_TRANSLATION

                create function dbo.UFN_EVENTREGISTRANTBATCH_EVENTREGISTRANTATTENDED_TRANSLATION(@ID tinyint) 
                returns nvarchar(50)
                as
                begin
                    declare @R nvarchar(50);
                    select @R = 
                        case @ID
                            when 0 then ' '
                            when 1 then 'Yes'
                            when 2 then 'No'
                            when 3 then 'No show'
                            else 'N/A'
                        end

                    return @R;
                end