TR_FINANCIALTRANSACTIONNOTE_INSERT_HTMLPOPULATE

                CREATE trigger TR_FINANCIALTRANSACTIONNOTE_INSERT_HTMLPOPULATE 
                    on dbo.FINANCIALTRANSACTIONNOTE 
                    after insert not for replication
                as begin
                    declare @INSERTEDHTML nvarchar(max)
                    declare @INSERTEDID uniqueidentifier

                    select @INSERTEDID = ID, @INSERTEDHTML = HTMLNOTE from inserted
                    if @INSERTEDHTML = ''
                    begin
                        update dbo.FINANCIALTRANSACTIONNOTE
                        set HTMLNOTE = replace(replace(replace(TEXTNOTE,'&','&amp;'),'<','&lt;'),'>','&gt;')
                        where ID = @INSERTEDID
                    end
                end