title: T-SQL LIKE regular expression
body: <p>I'm trying to select only entries in the following format from a varchar field.</p>
  
  <p>[Any number of zeros][a hyphen or not][any number of numbers]</p>
  
  <p>Some samples of what I want would be...</p>
  
  <pre><code>000000000007975
  000000000-58628
  123421423890347
  </code></pre>
  
  <p>But not:</p>
  
  <pre><code>00000--18945489
  00000000000012B
  
  SELECT Field&lt;br&gt;
  FROM table&lt;br&gt;
  WHERE Field LIKE ???
  </code></pre>