Remover retorno de carro en sql - Remover enter en campo sql

SELECT REPLACE(REPLACE(campodb,CHAR(10),''),CHAR(13),'') AS CampoDb
FROM tabla
WHERE campodb LIKE '%'+CHAR(13)+'%' OR campodb LIKE '%'+CHAR(10)+'%'