Casey, It's been a long time since I worked on SQL Server, but the decimal field should be correct. Are you sure scale and precision have been set correctly? Or is the rounding occurring at the front-end code? Jeffrey -- Cheers. Jeffrey Barke jeffery.barke at theMechanism.com Lead Developer, US theMechanism - New York City 440 9th Avenue, 8th Floor New York, NY 10001-1631 t: +1 212.404.3150 c: +1 917.941.1232 f: +1 212.404.3228 http://www.theMechanism.com Subscribe to theMechcast, our monthly Podcast: http://feeds.feedburner.com/theMechcast theMechanism - London 3rd Floor 405 The Strand London E14 9FW United Kingdom t: +44 (0)20 7240 4942 f: +44 (0)20 7240 2262 -- The information contained in this Electronic mail message is attorney privileged and confidential information intended only for the use of the individual or entity named above. Such information also is intended to be privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone. Blah, blah, blah... -- On May 23, 2007, at 4:52 PM, Casey Crookston wrote: > If I want to store the value of 1.5, what is the best datatype to > use? This is not currency, it's just 1 ½. I would have thought it > would be "decimal" but that seems to round up. > > > > Thanks, > > > > Casey > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !