How to remove new line characters and Tab's in the SQL output

Use this, It works fine.

select REPLACE(REPLACE(REPLACE(Column, CHR(10)), CHR(13)), CHR(9))  from Table