Your problem is Scale 0. Check out this page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_8rc5.asp
"Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2." If you have a precision of 18 and a scale of 0, that means you are allowed 18 digits total, but zero can be to the right of the decimal point, which would force your values to be stored as integers. Change the data type to a scale of 2 or 4 or however many digits you want to the right of the decimal point, and adjust your precision if necessary to allow the correct total number of digits. So, for example, if you want a maximum of say nine million nine hundred ninety-nine thousand nine hundred ninety-nine dollars and ninety-nine cents, you would do it like this: 9999999.99 = precision 9, scale 2 Dave -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:05 AM To: CF-Talk Subject: RE: Sql Server DECIMAL datatype 18. I previously had the datatype as money, but am in the process of trying decimal right now. Scale 0. These are default entries. ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
