UFN_GRADELEVEL_GETABBREVIATIONANDDESCRIPTION

                create function dbo.UFN_GRADELEVEL_GETABBREVIATIONANDDESCRIPTION(@ID uniqueidentifier) returns nvarchar(50) 
                as
                begin
                    declare @s nvarchar(113);
                    select @s = dbo.GRADELEVEL.ABBREVIATION + ' - ' + dbo.GRADELEVEL.[DESCRIPTION] from dbo.GRADELEVEL where dbo.GRADELEVEL.ID = @ID;
                    return @s;
                end