Remove carriage return line feed in T-SQL (SQL Server)

Remove carriage return, line feed and tab in T-SQL..

REPLACE(REPLACE(REPLACE(MyField, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')


Hope this will help..