Money Data Type

[jbenson001]

Was wondering if anyone had an opinion, or heard of any downfalls to using a money data type. I have a column that will store payment amounts. Was wondering if I should use money or something like a decimal(10,2). Any comments or suggestions would be appreciated.

Jim

 

[SQLDenis]

use decimal/numeric, money causes rounding problems

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

Thanks Denis. I thought I remembered something to that effect. I will use a decimal column.

Jim