On the CF side you could just display listFirst("$14.00",".")-----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:59 PM To: CF-Talk Subject: formattting my sell price Guys, Using SQL Server, small money field, trying to display my sell price the best way possible. Thing is, she wants just the real number displayed. So $14.00 should be displayed as $14. Suggestions please? Thanks much! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
