title: In SQL how can I convert a money datatype to a decimal?
body: <p>I want to convert a money datatype to a decimal, because I want to record the results to 8 decimal places.</p>
  
  <p>For example, in a currency rate table I see the rate stored as 2871047428.20 as a money datatype; using Microsoft SQL Management Studio, I want to divide that by 10000000 in order to achieve the result 287.10474282; however the result I am actually getting is 287.1047.</p>
  
  <p>I believe the reason I am getting only the 4 decimal places is because it is money datatype, and therefore I think the way forward is to convert this to a decimal datatype.... </p>