problem with float datatype and rounding and subnormal numbers
Posted on 2010-09-19
I am working with a SQL database that returns some amount. The data types for amount column is float and rounding is alredy applied in the calculation.
The problem that I have at the moment is that I need to display all the record that have their amount as:
tblX.ColAmount > 0
the problem is that the ColAmount contains values such as: 0.000123-e12
I am not sure what this exactly does but the values are not returning anymore.
the questions are:
what is exactly this value 0.000123-e12 is and why they are stored in this way in the database ?
How should I define this comparison tblX.ColAmount > 0 to get missing records displayed?
Thanks in advance