title: T-sql - determine if value is integer
body: <p>I want to determine if a value is integer (like <code>TryParse</code> in .NET). Unfortunatelly <code>ISNUMERIC</code> does not fit me because I want to parse only integers and not every kind of number. Is there such thing as <code>ISINT</code> or something?</p>
  
  <p>Here is some code to make things clear. If <code>MY_FIELD</code> is not int, this code would fail:</p>
  
  <pre><code>SELECT @MY_VAR = CAST(MY_FIELD AS INT)
  FROM MY_TABLE
  WHERE MY_OTHER_FIELD = 'MY_FILTER'
  </code></pre>
  
  <p>Thank you</p>