update and substr command

[svk]

UPDATE table_name
SET po_number=replace(upper(po_number),'PO','');

should do what you want. Alternatively :

UPDATE table_name
SET po_number=substr(po_number,3);

Test the things first.