>First, I have the ORG table selected and then do the following:
>

>REPLACE auth.end WITH DATE() FOR ;
>     auth.organization = org.organization AND ;
>     (auth.end > DATE() OR EMPTY(auth.end))

>
>and it moves the record pointer of the ORG table. Why?
>
>Chuck


The FOR clause says "SCAN the current table for the condition".