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.