title: SQL - Query Phonenumber that are stored inconsistently
body: <p>we a phonenumber field in our database and I would like to do a simple lookup query like: </p>
  
  <pre><code>SELECT * FROM TABLE WHERE Phonenumber = '555123456'
  </code></pre>
  
  <p>But since the phonenumbers are entered by users and are not normalized, we don't really know what they look like.</p>
  
  <p>Could be:</p>
  
  <ul>
  <li>+555-123456</li>
  </ul>
  
  <p>or</p>
  
  <ul>
  <li>(555) 123 456</li>
  </ul>
  
  <p>or</p>
  
  <ul>
  <li>555-12-34-56</li>
  </ul>
  
  <p>or something complety different.</p>
  
  <p>The only thing certain is that the all the given numbers should be there in the correct order. Is it possible to construct a query around that?</p>