UFN_EDUCATIONALHISTORY_GETFULLNAMEEDUCATIONALINSTITUTION

                CREATE function dbo.UFN_EDUCATIONALHISTORY_GETFULLNAMEEDUCATIONALINSTITUTION(
                    @ID uniqueidentifier
                ) returns nvarchar(700)
                    as begin
                        if @ID is null
                            return '';

                        return coalesce((
                            select
                                NF.NAME + ': ' + EI.NAME FULLNAMEEDUCATIONALINSTITUTION
                            from
                                dbo.EDUCATIONALHISTORY EH
                            left join
                                dbo.EDUCATIONALINSTITUTION EI on EI.ID = EH.EDUCATIONALINSTITUTIONID
                            outer apply
                                dbo.UFN_CONSTITUENT_DISPLAYNAME(EH.CONSTITUENTID) NF
                            where
                                EH.ID = @ID), ''
                        );
                    end