UFN_TRANSLATIONFUNCTION_MEMBERSHIPLEVELTERM_GETNAME

            create function dbo.UFN_TRANSLATIONFUNCTION_MEMBERSHIPLEVELTERM_GETNAME
            (
                @ID uniqueidentifier
            ) returns nvarchar(8) 
            as
            begin
                declare @TERM nvarchar(8);
                select
                    @TERM = MEMBERSHIPLEVELTERM.[TERM]
                from
                    dbo.MEMBERSHIPLEVELTERM
                where
                    MEMBERSHIPLEVELTERM.[ID] = @ID;

                return @TERM;
            end