title: Error converting a numeric string to decimal places
body: <p>Can someone help me understand why the first one does not work and the second one works</p>
  <ol>
  <li><code>SELECT CONVERT(numeric(11, 2), NULLIF('4702137480', '')) / 100.00</code>.<br />
  Error Message:
  <blockquote>
  <p>Msg 8115, Level 16, State 8, Line 1<br />
  Arithmetic overflow error converting varchar to data type numeric.</p>
  </blockquote>
  </li>
  <li><code>SELECT CONVERT(numeric(12, 2), NULLIF('4702137480', '')) / 100.00</code>.<br />
  Result 47021374.80000000</li>
  </ol>
  <p>My understanding was <code>11, 2</code> meant a total of 11 and the last two are after the decimal place. As the example only has 10 digits I don't understand why it does not work.</p>