Simple query to capitalize?

[menuserve]

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?

[guelphdad]

use UPPER