hi all,

i need help to replace at mytable field1 with field2
i have numbers at field2 , 1,2,3,4,5,6,7,8,9,10,13,16,17,19,20,40,41,42,43,44,54,55,56,57,58,59
60,61,62,63,64,66,67,68,69,89,90,99

ex..
field1  field2
1      1
2    2345
3    8765
4    987
       2
1    2672
2    09876
3    87654
4     1287
       3
.
.*****************i need to replce it as

1      1
1    2345
1    8765
1    987
       2
2    2672
2    09876
2    87654
2     1287
       3
3     7654
3     3456
3     7654
3     3987
        4
.       .
.

thanks