title: Find or Strip Invalid characters from Database
body: <p>We are using a database where the front end software has allowed the input of invalid characters. (I have no control or re-writing of the software.)</p>
  
  <p>The types of characters are carriage returns, line breaks, �, ¶, basically anything that is not 0-9, a-z or standard punctuation causes us issues with the database and how we use the data. </p>
  
  <p>I'm looking for a way to scan the entire database to identify these invalid codes and either display them as results or strip them out?</p>
  
  <p>I had been looking at <a href="http://www.ssec.wisc.edu/~tomw/java/unicode.html" rel="nofollow">This site</a> wondering if there was a way of searching for a certain range? But I might be barking up the wrong tree.</p>
  
  <p>I'm fairly new to SQL so be gentle with me, thanks.</p>