TR_FINANCIALTRANSACTIONNOTE_INSERT_HTMLPOPULATE (Trigger)

                
                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