UPDATE t_dept_info di SET di.dept_short_name = REPLACE(REPLACE(di.dept_short_name,CHAR(10),''),CHAR(13),'')