title: CONVERT NUMBERS IN 'WHERE' STATEMENT TO INCLUDE DASHES IN SQL Server
body: <p>I have quite a lot of numbers in <code>xxxxxxxxx</code> format that I need to put in a <code>WHERE</code> clause in SQL Server. However, SQL Server will only recognize them if they are in a <code>xxx-xx-xxxx</code> format.</p>
  <p>How do I add in the dashes in to the where statement in sql?</p>
  <p>In summary, in WHERE statement, I need:</p>
  <pre><code>xxxxxxxxx
  </code></pre>
  <p>to be recognized in this format:</p>
  <pre><code>xxx-xx-xxxx
  </code></pre>