title: Search only on alphanumeric chars of a column
body: <p>I have a table column of type nvarchar.<br>
  As an example, lets say one of the records is <code>A320 - Airbus</code>. 
  Contains both alphanumerics and a hyphen in this case.</p>
  
  <p>When I search for <code>320A</code>, the search should pick it up by ignoring the 2 whitespaces and a hyphen between the 2 words. </p>
  
  <p>Currently, I can achieve this by doing this</p>
  
  <pre><code>SELECT DISTINCT Name 
  FROM Entity
  WHERE REPLACE(REPLACE(Name, ' ', ''), '-', '') LIKE '%320A%'; 
  </code></pre>
  
  <p>But if I have to add more escape chars, I have to keep applying <code>REPLACE</code> for every new escape char. </p>
  
  <p>Would be good if I could do something like this:</p>
  
  <pre><code>SELECT DISTINCT Name
  FROM Entity
  WHERE REGEXP(Name, '^[A-Za-z0-9]+$') LIKE '%320A%';
  </code></pre>