UFN_SCHOOL_GETNAME

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

                    select
                        @NAME = CONSTITUENT.KEYNAME
                    from
                        dbo.SCHOOL
                    join
                        dbo.CONSTITUENT on CONSTITUENT.ID = SCHOOL.ID
                    where
                        SCHOOL.ID = @ID;

                    return @NAME;
                end