title: Regex for one column that has numbers and letters but not one or the other
body: <p>I am attempting to search a column that contains alphanumeric ids in it but want to write a query that returns records with letters and numbers but not one or the other.</p>
  
  <pre><code>i.e Acceptable: jjk44kndkfndFF
  
  i.e Not acceptable: 223232323232   or  aajnfdskDFdd
  </code></pre>
  
  <p>So far I have:</p>
  
  <pre><code>where  PATINDEX('%[^a-zA-Z0-9 ]%',columnInQuestion)
  </code></pre>
  
  <p>This returns all alphanumeric records. Any direction appreciated</p>