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