UFN_FINANCIALINSTITUTION_GETINSTITUTIONNAME

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

                select 
                    @INSTITUTIONNAME = FINANCIALINSTITUTION
                from
                    dbo.FINANCIALINSTITUTION
                where
                    ID = @ID;

                return @INSTITUTIONNAME;
            end