TR_CONSTITUENTNOTE_INSERT_HTMLPOPULATE

                CREATE trigger TR_CONSTITUENTNOTE_INSERT_HTMLPOPULATE on dbo.CONSTITUENTNOTE after insert not for replication
                as begin
                  update dbo.CONSTITUENTNOTE
                  set HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(TEXTNOTE)
                  where ID in(select ID from inserted)
          and HTMLNOTE = ''
          and TEXTNOTE <> ''
                end