title: Convert nvarchar data to decimal
body: <p>I have data stored in a <code>nvarchar(10)</code> column that I need to convert to <code>decimal(10,3)</code>. Each record is a full 10 characters with leading zeros. The last three numbers represent decimals. How do I convert the following example?</p>
  
  <pre><code>col1
  ----------
  0000100001
  0002507630
  0090078607
  0258736000
  </code></pre>
  
  <p>Expected Output</p>
  
  <pre><code>col1                   col2
  -------------------------------
  0000100001              100.001
  0002507630             2507.630
  0090078607            90078.607
  0258736000           258736.000
  </code></pre>
  
  <p>I tried using </p>
  
  <pre><code>Cast(covert(decimal(10, 3), col1) as Decimal(10, 3)) as col2
  </code></pre>
  
  <p>The output I receive is</p>
  
  <blockquote>
    <p>Arithmetic overflow error converting nvarchar to data type numeric.</p>
  </blockquote>
  
  <p>How do do properly convert this data?</p>