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), '')
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)