UFN_EDUCATIONALINSTITUTION_GETNAME

                CREATE function dbo.UFN_EDUCATIONALINSTITUTION_GETNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(100)
                with execute as caller
                as begin
                    declare @NAME nvarchar(100);

                    select
                        --@NAME = NAME

                        @NAME = case when ISAFFILIATED = 1 then NAME + ' *' else NAME end
                    from dbo.EDUCATIONALINSTITUTION
                    where
                        ID = @ID;

                    if @NAME is null
                        return '';

                    return @NAME;
                end