Look at the number formatting functions. They'll be one in there that'll do what you're after.
cfquickdocs.com Adrian -----Original Message----- From: Steven Sprouse [mailto:[EMAIL PROTECTED] Sent: 12 April 2007 14:34 To: CF-Talk Subject: Altering display of data from SQL database I have data in a SQL database that I want displayed with commas on my web page (ex. data is stored as 1234 and I want it displayed as 1,234. Does anyone know how I would go about doing this? I'm assuming I need a cfif statement, but I'm not sure if there is a specific function I should use or not. Please help! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
