UFN_TRANSLATIONFUNCTION_GROUPGOAL_GETNAME

            CREATE function dbo.UFN_TRANSLATIONFUNCTION_GROUPGOAL_GETNAME
            (
                @ID uniqueidentifier
            ) returns nvarchar(50)
            as
            begin

            declare @NAME nvarchar(50);

            select
                @NAME = GROUPGOAL.[NAME]
            from dbo.GROUPGOAL
            where GROUPGOAL.[ID] = @ID

            return @NAME;
            end