update <table>
   set Adapted_code = 'A' + code
...