UFN_EVENTDESIGNATION_GETNAME

                create function dbo.UFN_EVENTDESIGNATION_GETNAME
                (@ID uniqueidentifier) 
                returns nvarchar(100) 
                with execute as caller
                as
                begin

                    declare @NAME nvarchar(100);
                    select @NAME = case VANITYNAME
                        when '' then NAME
                        else VANITYNAME end
                    from dbo.DESIGNATION where [DESIGNATION].[ID] = @ID;

                    return @NAME;
                end