title: SQL Data Conversion
body: <p>Any ideas why this won't work?</p>
  <pre><code> Select [Name]
        ,TimeStamp
        ,UserKey
        ,Field
        ,WasValue
        ,Cast(IsValue as int)
      From DebtorHistory
      Left Join Debtors on Debtors.DebtorKey = DebtorHistory.DebtorKey
      Where Field = 'Total Credit Limit'
      and TimeStamp &gt; GETDATE()-7
  </code></pre>
  <p>I'm getting this error when trying to convert isValue to int:</p>
  <blockquote>
  <p>Conversion failed when converting the nvarchar value '15,000.00' to data type int.</p>
  </blockquote>