-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Burcaw Sent: Monday, July 24, 2006 16:03 To: [email protected] Subject: Re: searching for a penny
I've spent WAY too much time chasing a penny here and there. I've found that it is best to convert the currency field to a numeric first. Actually, I've found that it is best to avoid the currency data type like the plague. ========================================== Where did the Currency data type come into play here? All Andrew said was that he is using 4 decimal places of precision. There is nothing wrong with the Currency data type. As a matter of fact, I use it for all of my numerics (generally) because it is compact and runs faster since no time is spent converting decimal values to binary. The x-base numeric representation is very 1960's, IMHO. Of course that makes it a prime candidate for Microsoft to bring it back into use under XML. :) HALinNY [EMAIL PROTECTED] www.mymacaronilife.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
