On any field you want to change to upper case in the customer file, run the following sql statement, changing the customer_name to whatever field he wants to update.


UPDATE customer SET customer_name = UCASE(customer_name);

The above sql statement would change the customer name to upper case. If I wanted to change the main_city I would do the following:


UPDATE customer SET main_city = UCASE(main_city);