Let's say your most-expensive item is $1000.00. You need to set your precision to the total number of digits, including the decimal portion, but excluding the decimal. Then, you set the scale to the number digits after the decimal.
In this example, the precision is 6, the scale is 2. Obviously, make the precision large enough to hold your largest cost. M!ke -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 9: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. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217091 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
