Extract时去除硬回车

SELECT
DNLogID,
CMPTxID,
ActionType,
REPLACE(REPLACE(DNLog.Remark, CHAR(10),''), CHAR(13),'') as Remark,   -- 去除所有的硬回车
StatusCode,
CreateDate
FROM
DNLog
where
CONVERT(varchar(10),CreateDate,23) >= ${Exact_StartDate}
AND
CONVERT(varchar(10),CreateDate,23) <  ${Exact_EndDate}