select REPLACE(REPLACE(field_name, '\r', ''), '\n', '') -- OR select REPLACE(REPLACE(field_name, '\\r', ''), '\\n', '') -- OR select REPLACE(REPLACE(field_name, CHAR(10), ''), CHAR(13), '')
select REPLACE(REPLACE(field_name, '\r', ''), '\n', '') -- OR select REPLACE(REPLACE(field_name, '\\r', ''), '\\n', '') -- OR select REPLACE(REPLACE(field_name, CHAR(10), ''), CHAR(13), '')