Is this some kind of trick question?
update yourtable set columna=upper(columna), columnb=upper(columnb)
2
solved The most efficient way to UPPER CASE two columns in a single query [closed]
Is this some kind of trick question?
update yourtable set columna=upper(columna), columnb=upper(columnb)
2
solved The most efficient way to UPPER CASE two columns in a single query [closed]