how to control decimal points?

• karthimca07

  Mr or Mrs. 500

  Points: 578

  More actions

  August 6, 2009 at 1:08 am

  #72861

  i have a table with filed name as roundoff off type float.

  when i'm inserting the value 8.09 it stored as 8.0000000000000002E-2

  how to avoid this. i need only two or three decimal points..

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  August 6, 2009 at 2:06 am

  #1035218

  It's not the way it's stored, it's the way it's presented to you on SELECT.

  If you want another presentation use CONVERT or STR functions.

  But use them only for presentation, not when you do calculations.

  _____________
  Code for TallyGenerator