title: SQL Server : How to test if a string has only digit characters
body: <p>I am working in SQL Server 2008.  I am trying to test whether a string (varchar) has only digit characters (0-9).  I know that the IS_NUMERIC function can give spurious results.  (My data can possibly have $ signs, which should not pass the test.)  So, I'm avoiding that function.</p>
  
  <p>I already have a test to see if a string has any non-digit characters, i.e.,</p>
  
  <pre><code>some_column LIKE '%[^0123456789]%'
  </code></pre>
  
  <p>I would think that the only-digits test would be something similar, but I'm drawing a blank.  Any ideas?</p>