UFN_CLASS_GETNAME

                CREATE function dbo.UFN_CLASS_GETNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(60)
                as
                begin
                    declare @NAME nvarchar(60);

                    select
                        @NAME = (COURSE.COURSEID + ' - ' + CLASS.[SECTION])
                    from dbo.CLASS
                        left join dbo.COURSE on dbo.CLASS.COURSEID = dbo.COURSE.ID
                    where CLASS.[ID] = @ID;

                    return @NAME;
                end