title: Need a way of finding special characters in data using SQL query
body: <p>I am trying to find special characters in any of my fields that are not in the range of a-zA-Z0-9. However if I try this query: </p>
  
  <pre><code>select Name from table where Name like '%[?]%'
  </code></pre>
  
  <p>I get two records:</p>
  
  <ul>
  <li>???? ?????</li>
  <li>Fixed?????</li>
  </ul>
  
  <p>Which is what I want. However, since I don't know what the special chars will be I need to use an exclusion of data that has mixed characters: </p>
  
  <pre><code>select Name from table where Name NOT like '%[a-zA-Z0-9]%'
  </code></pre>
  
  <p>Since this excludes all records with a-zA-Z0-9 I only get: </p>
  
  <ul>
  <li>???? ?????</li>
  </ul>
  
  <p>But I also need to get the 'Fixed?????' result. I need to get the data that has the special character merged into it. </p>
  
  <p>I am bit at a loss as how to do this. I've seen this done with shell scripts or 'vi' (LIST), but in SQL that's not so easy. </p>
  
  <p>Has anyone out there solved this? </p>