Hi Hilmar,
I notice you made the same typo as I 'always' make, by typing 'where' instead of 'for'
replace all docdesc with upper(docdesc) for between(IDField, 195000, 200000)
At a VFP devcon some years ago, the VFP team asked the audience for suggestions for improvements and enhancements to the language, and I suggested that they added 'where' to all the commands where you could use 'for', so 'for' and 'where' would be treated equal.
>>Could you please tell me, how i can do an update on a table from command window specifying where the table is.
>>
>>My table name is Doctable
>>field name is docdesc
>>
>>Table is a free table: located at c:\myproject
>>
>>I want to convert all the docdesc columns data from lower case to upper case.
>>
>>i have 200,000 records in table, but i want to convert records between ID:195,000 to 200,0000
>>
>>Update doctable set docdesc from lowercase to upper case.
>>
>>Thank you very much for the help.
>
>
>cd c:\myproject
>use Doctable
>replace all docdesc with upper(docdesc) where between(IDField, 195000, 200000)
>
>
>If with "ID" you mean recno(), replace that in the REPLACE command above.