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. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
