>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
Rabdy,
Create an index on Posted and do this;
REPLACE Posted WITH "JUL02" FOR Posted = SPACE(LEN(Posted))