Are you sure you don't want TO_CHAR('28')||'-'||column1?
Or even '28-'||column1. By adding the - you are making a char or a varchar2.
|
Results 1 to 6 of 6
Thread: to_numberThreaded View
|
Click Here to Expand Forum to Full Width |