>I am a VFP7 user. I have a database with approx 50,000 records.
>The "posted" field has the month/year that each transaction was posted (to the acctg ledger).
>
>At the end of this month, I will issue the command:
>
>REPLACE ALL posted WITH 'JUL02' FOR EMPTY(posted)
>
>Wow! is it slow. Can anyone help me optimize the operation?
>
>Thanks, Randy


update myTable set posted = 'JUL02' where posted == ''

Cetin