Remove Hidden Characters

Here is great way to remove "hidden" characters from data being imported in SQL Server. These characters are common when importing flat file data.

MetaDeveloper: Remove Carriage Return, Line Feed, Tab in TSQL: "-- remove carriage return, line feed, and tab from a field in tsql
REPLACE(REPLACE(REPLACE(MyField, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')"