UFN_SCHOOLGRADELEVEL_GETNAMEDESCRIPTION

                CREATE function dbo.UFN_SCHOOLGRADELEVEL_GETNAMEDESCRIPTION(@ID uniqueidentifier) returns nvarchar(111) 
                as
                begin
                    declare @s nvarchar(111);

                    select @s = 
                        dbo.GRADELEVEL.ABBREVIATION + ' - ' + dbo.GRADELEVEL.DESCRIPTION
                        from dbo.SCHOOLGRADELEVEL 
                        inner join dbo.GRADELEVEL on dbo.SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
                        where dbo.SCHOOLGRADELEVEL.ID = @ID;

                    return @s;
                end