try making the field "decimal" with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists