Hi Everybody,

I have a table having a column as varchar2.The column has at present data of many rows.

The data stored in the column are for e.g..

10
2508
NU-CMA13
1
45
....
....

Now i want to update the column data like wherever there are numeric data like 10 it needs to be updated as 4 digit(padded with 2 leading zeroes) so the data should look like...

0010
2508
NU-CMA13
0001
0045
....
....

Pls if anybody kknows the solution...Thanks in advance

pras