float data type in sql2005 and sql2000

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  February 14, 2006 at 10:51 pm

  #70285

  Hi ,

  i was using sql2000 in which one table has float datatype and when i query it gives result like

  20.000000000000004

  but same thing when i query in sql2005 i get only 20.

  do i need to change anything in sql2005.

   

  thanks

   

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  February 15, 2006 at 1:14 am

  #620910

  Float is an approximate datatype so you can get some unusual values for seemingly simple maths.

  Decimal and Numeric are precise values.

  LinkedIn Profile