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