REPLACE with a condition (FOR/WHILE) will move the record pointer, do the REPLACE, move again. REPLACE without a condition affects the current record only.
>PMFJI,
> but how can that be true for REPLACE, when you can put the clause FOR myTable.myfield = m.myvariable and put WHERE myTable.myfield = m.myvariable on the UPDATE command, which could potenially (sp?) move either of them.
>
>TIA
>Beth
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
