Remove hidden characters in a column SQL SERVER

How do you remove hidden characters like a carriage return or any other unknown characters from columns?  
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
each character has an ascii code, like carriage return and line feed have char(10) and char(13).
so, simply do

UPDATE yourtable
  SET yourcol = REPLACE(REPLACE(yourcol, char(13), ''), char(10), '')
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.