change small letter to capitals letters

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
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