Sqlserver中将字段中带有的"回车键"和"换行键"进行替换

SELECT REPLACE(REPLACE(REPLACE(A,char(13), ''),char(10),''),',',',') AA
,REPLACE(REPLACE(REPLACE(B,char(13), ''),char(10),''),',',',') BB
FROM [CC]