>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
