convert to uppercase in specific table

Hi All,

I'm a newbie here, i'm just wondering is it possible to convert into uppercase the records in specific field?

ex.
table name = mytable

field1 field2 field3
abd erfdF fdsfdsfsd

how can i convert into uppercase the field2 using sybase?

Please advise,

Thanks,

use upper function.

select upper(field2) from mytable

modify the query for "update" accordingly.

 
update mytable set field2 = upper(field2)

careful, it is not used any where condition. so it will update all the data in the second column