sql 替换字段中的换行符

select distinct replace(replace(name,char(13),''),char(10),'') From  tb_test