Sql Server Programming :: Calculations in SQL


	Calculations in SQL What data ype manipulations do I need to apply to get 'select 10/100' giving me a result of 0.1 instead of 0 -- obelix "Whether you think you can or you think you cant you are right" .... Anon Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2007... Hi, Convert the 100 to a numeric of whatever size you want select 10/convert(numeric,100) - Greg O SQL Server Documentation the easy way SQL 2000, SQL 2005 the best is back http://www.geckoware.com.au/Content.aspx?Doc_id=1001 "obelix via SQLMonster.com" <u24035@uwe> wrote in message news:72e3dcde8af66@uwe... - Hide quoted text - > What data ype manipulations do I need to apply to get 'select 10/100' > giving > me a result of 0.1 instead of 0 > -- > obelix > "Whether you think you can or you think you cant you are right" .... Anon > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2007... On May 29, 12:33 pm, "obelix via SQLMonster.com" <u24035@uwe> wrote: > What data ype manipulations do I need to apply to get 'select 10/100' giving > me a result of 0.1 instead of 0 > -- > obelix > "Whether you think you can or you think you cant you are right" .... Anon > Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2007... select 10/100.00