FWIW - Every accounting package that I've worked with carries money values to at least three decimal places.
HTH
================================================================= Every act of conscious learning requires the willingness to suffer an injury to one's self-esteem. That is why young children, before they are aware of their own self-importance, learn so easily; and why older persons, especially if vain or important, cannot learn at all. -Thomas Szasz, author, professor of psychiatry (1920- )
If you only need to DISPLAY 2 decimal places, but not actually round off the value, then do it in your application/presentation layer, or use the CONVERT() or STR() SQL functions to convert it to a string/varchar.
You are better off using money/smallmoney rather than decimal if you're storing monetary values. As Bustaz said, you get more accuracy with money, and it's more efficiently stored and calculated than decimal types.
Two digits after decimal point
Posted - 04/15/2005 : 12:22:12
