Real data type value getting changed when reading thru a datareader

Not all numbers are precisely represented, please read this article to better understand the matter :

http://sqlmag.com/sql-server/tip-when-real-not-real

Hope this clarifies things !

What should I do to get the correct number.

Thanks.

if possible, change the datatype to "decimal" which, unlike "float" and "real", is not an approximate data type.

Also note, it's not the DataReader that changes the value, it's the way the value is stored. When you store "11.11" in as a real, what is stored is an approximation of that number, which is returned when you read it through the DataReader.

Is there anyway I can store the real value and get it as it is without any change?

Thanks.

Only way I see is rounding the value to the amount of decimal you need, which may not be a good idea depending on what exactly those numbers represent and how they are used afterward. You should not store them as real if they need to be retrieved exactly as entered.

Thank u.