-- retraitement des reponses en attente pour forcer le bon format telephone
update coregistration.coregistration_reponse
set coregistration_reponse_id_reponse = REGEXP_REPLACE(REPLACE(coregistation_reponse_id_reponse, '+33', ''), '[^0-9]', '', 'g')
from coregistration.coregistration
where coregistration_coregistration_affichage = coregistration_reponse_affichage
and coregistration_reponse_id_question = 574
and coregistration_campagne_annonceur = 836
and coregistration_champ = 1
and coregistration_eligible = 1;