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