UFN_CORECURRICULUM_GETNAME

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

                    select @NAME = CORECURRICULUM.NAME
                    from dbo.CORECURRICULUM
                    where CORECURRICULUM.[ID] = @ID;

                    return @NAME;
                end