SQL 替换回车符

select * from dbo.luDefectupdate luDefectset Description= REPLACE(Description, CHAR(13), '')where REPLACE(Description, CHAR(13), '<br>') like '%<br>%'