Right. Every situation requires its own thought and its own solution. Also, a REPLACE FOR can be quite slow (justifiably) on a large table.

Thanks for the input.

Joe

>Be aware that REPLACE FOR or WHILE will lock the table, while the SCAN ... REPLACE ... ENDSCAN lock only the current record. In this case, being a cursor, it doesn't matter so much.
>
>Vlad
>
>>You can use the REPLACE...FOR command, or REPLACE...WHILE command and do this with a lot fewer lines. You can replace many fields with one REPLACE.