telastruct (12/6/2010)
Here's another approach:http://iso30-sql.blogspot.com/2010/10/remove-non-printable-unicode-characters.html
Thanks for the link and welcome aboard! Shifting gears, please be sure to test that code from that link for performance before you think of using it because it's likely a whole lot slower than the code already posted on this thread because of the scalar function with a While loop in it. The "nested REPLACE" code posted on this thread will absolutely fly.
--Jeff Moden
Change is inevitable... Change for the better is not.