title: ISNUMERIC on VARCHAR Column returning numbers still?
body: <p>Why does ISNUMERIC = 0 return numbers with spaces and '/' ? 
  This is SQL Server 2008 R2 BTW</p>
  
  <p>Thanks Guys,</p>
  
  <p>Code Sample: </p>
  
  <pre><code>  SELECT A AS 'VARCHARCOLUMN' FROM TABLE
      WHERE ISNUMERIC(A) = 0
  
      TABLE Structure:
      ----------------------
          A  |   B    |   C   |
      ----------------------
        x    |        |       |
        .    |        |       |
        p    |        |       |
       1 7/2 |        |       |
       15.   |        |       |
        5    |        |       |
  
  
        Result set:
     ----------------------
          A  |   B    |   C   |
      ----------------------
        x    |        |       |
        p    |        |       |
       1 7/2 |        |       | &lt;- Why is this returned???
  </code></pre>