update diagnosis
set
 icd9_code_id = Replace(icd9_code_id, '.', '')
where length(icd9_code_id) = 4