update c:\myproject\doctable set docdesc=upper(docdesc) where between(IDField, 195000, 200000)

>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.