RE: MSSQL decimal issue

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

MSSQL decimal issue

select (15 / 11.24) returns 1.334519 - Fine select (13/15) returns 0 ( not 0.8 ... ) How can I get sql server to return the decimal information? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Re: MSSQL decimal issue

select (cast(13 AS DECIMAL) / cast(15 AS DECIMAL)) Thanks Brother! ~| 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