Simple query to capitalize?

Databases
1

I have a column in my table that has some words that are lowercase, some that have a capital first letter and the rest lowercase.

Is there a query I can run to update all of the fields to CAPITAL letters?

2

use UPPER