diveshps (9/27/2012)
Laurie,Thank you for your reply.
I guess if I force a cast to a decimal it will work since that is what happens when I add the "* 1.0" but I thought money or smallmoney was a decimal number.
Even if I change the datatype to money, I get the same results.
If we have to force a cast or conversion to a decimal type then does it mean that there is no point in using the money or smallmoney data type? !!! I hope this is not the conclusion of this. 🙂
Thanks for any more leads on this.
Regards
Divesh
Speaking for myself, I always use DECIMAL to store dollar amounts to avoid exactly this sort of issue. I've never seen the point of money or smallmoney.