title: IsNumeric in SQL Server JOIN
body: <p>My problem seems to be very simple but I'm stuck here. I have a table which has an "nvarchar" column called "SrcID" and I store both numbers and strings in that. Now, when I try to check for "IsNumeric" on that column in a "Join" condition, something like below,</p>
  
  <pre><code>   ISNUMERIC(SrcID) = 1 AND SrcID &gt; 15
  </code></pre>
  
  <p>I am getting the following error:</p>
  
  <pre><code>  Msg 245, Level 16, State 1, Line 47
    Conversion failed when converting the nvarchar value 'Test' to data type int.
  </code></pre>
  
  <p>Amazingly, when I remove the check "SrcID > 15", my query is running properly. Should I include anything else in this statement?</p>
  
  <p>Please help me in fixing the issue. Thanks in advance!!</p>