select concat('*', SUBSTR(patient_name FROM 2 FOR length(patient_name))) from bi_patient_visit ;
update bi_patient_visit set date_id=replace(date_id,'2020-10-29','2020-11-01')
select concat('*', SUBSTR(patient_name FROM 2 FOR length(patient_name))) from bi_patient_visit ;
update bi_patient_visit set date_id=replace(date_id,'2020-10-29','2020-11-01')