Search field and replace two others
Posted on 2013-11-27
This may be simple to all but just cant get my head around :(
I would like to search for a value in FA_COST_NOM and if found replace the values in both FA_DISP_NOM and FA_REVAL_NOM, all three fields are in the same FA_ACCOUNTS table.
FA_COST_NOM FA_DISP_NOM FA_REVAL_NOM
11980 11960 11950
If 11980 is found change the other two fields to 11960 and 11950 respectively. There may be multiple records with 11980 in them.