UPDATE disease_types
SET adapted_code = "A" || code;