title: tsql casting to money rounds up
body: <p>When casting a varchar value to MONEY it is rounding the value to the nearest 0.10, how do I prevent this rounding up?</p>
  
  <p>UPDATE: I found the problem. In a subquery, the value is being CAST from varchar to FLOAT and then I was trying to CAST from FLOAT to MONEY.</p>