>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
If there is no simple rule to get Field2 from Field1, you can have a lookup table, a table of equivalences. I am assuming that 807 will always be equivalent to 803, for example.
From the original table, you can SET RELATION into the lookup table, and then replace Field2.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)