UFN_RECOGNITIONLEVEL_GETNAME

                create function dbo.UFN_RECOGNITIONLEVEL_GETNAME(@ID uniqueidentifier) returns nvarchar(100) 
                as
                begin
                    declare @NAME nvarchar(100);
                    select @NAME = NAME from dbo.RECOGNITIONLEVEL where ID = @ID;
                    return @NAME;
                end