UFN_MATCHCODE_GETNAME

            create function dbo.UFN_MATCHCODE_GETNAME(@ID uniqueidentifier)
            returns nvarchar(3)
            with execute as caller
            as begin
                declare @MATCHCODENAME nvarchar(3);

                select 
                    @MATCHCODENAME = MATCHCODE 
                from 
                    dbo.MATCHCODE
                where 
                    ID = @ID;

                return @MATCHCODENAME;

            end