decimal. i think i just found it :) thanks anyway..... stony
-----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:38 PM To: CF-Talk Subject: dollar format _ sql datatype hi there. whats the best data type in MSSqlServer so that i can sort by dollar amount. meaning this.. if the values of this select statement: select amounts from myDatabase order by amounts DESC was: amounts ---------- 19.95 15.67 12.00 not int or big int? is it numeric or float? ..tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ______________________________________________________________________ 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
