change small letter to capitals letters

I need to change over 300 records in a table field that have small letters t
o
capitals letters. Which sql command statement would change this?
Thanks in advance
DaveExample:
update table1
set c1 = upper(c1)
AMB
"DCR" wrote:

> I need to change over 300 records in a table field that have small letters
to
> capitals letters. Which sql command statement would change this?
> Thanks in advance
> Dave