It can be done in 1 update:
update tablename set PONUMBER = to_number(to_char(ltrim(substr(PONUMBER,3,8))));
Assumption the column length is 10.
|
Results 1 to 5 of 5
Thread: update and substr command
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote