You'll need to cast along the way. 13/15 is saying INT/INT
15/11.24 is saying DECIMAL/DECIMAL Maybe! Adrian http://www.adrianlynch.co.uk/ -----Original Message----- From: Dan Sent: 30 January 2008 11:24 To: CF-Talk Subject: MSSQL decimal issue select (15 / 11.24) returns 1.334519 - Fine select (13/15) returns 0 ( not 0.86666 ... ) How can I get sql server to return the decimal information? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4