>Sergey,
>
>I am incorrect the FOR applies to the Target of the append. That is why FOR NOT DELETED() doesn't work as one might expect as the records in the target are not deleted().

Hi Jim,

Just want to clarify. In case if the source is a table FOR clause still applies to the source. In this case NOT DELETED() does work as expected. I just tested that. In case if the source isn't a table NOT DELETED() is irrelevant.