update table_name
   set destination_column = "A" + source_column
 where some_condition