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 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

