Sunday, August 28, 2011

remove carriage return, line feed, and tab from a field in SQL

-- remove carriage return, line feed, and tab from a field in tsql
REPLACE(REPLACE(REPLACE(FieldName, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')