How to remove new line characters and Tab's in your SQL output
select comment from emp
Result (Comment column value is )
John M.
This was a
Fine piece of
work.
select REPLACE(REPLACE(REPLACE(comment, CHR(10)), CHR(13)), CHR(9)) comment from emp
Result (Comment column value is )
John M.This was a Fine piece of work.
