>Dear Experts
>
>Field1 of Table1 has character type date, but digits.
>In Field2, I want to replace data as under
>
>801--------801
>803--------802
>807--------803
>809--------804
>
>902--------901
>905--------902
>906--------903
>908--------904
>
>
>In second column data is written by 1 digit addition but the first digit remain same.
>
>Please help
One time job or not?
I mean did you care about speed or not?
Becuase first answer that comes to my mind is not very speedy :o)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.