replace special charcters in phone number

replace special charcters in phone number

update T_profiles set profile_phone1=replace(replace(replace(replace(profile_phone1,'-',''),'',''),')',''),'(','')

where profile_id