replace syntax to remove the extra spaces in the column for a table

update table_name set column_name=replace(replace(DEA, CHR(10),''), CHR(13),'');