IF all of the data is formatted as nicely as your example, you could try something like
UPDATE my_table
SET ord_num = substr(ord_num,1,10)||substr(ord_num,-4,4);
|
Results 1 to 3 of 3
Thread: sqlThreaded View
|
Click Here to Expand Forum to Full Width |