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

Reply via email to