The SQL Script below can be used to remove non-printable characters from a string such as CRLF etc. -- Create a Table to store the strings with non printable ASCII Characters CREATE TABLE ##NoPrintableStrings ( BadStrings VARCHAR(20) ) GO --Insert some
Read More...