if its float or real, its an approximate data notation so would try to display it in scientific notation if number of significant figures after decimal is large. If you want exact value to be considered, use decimal or numeric with required scale value specified
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Float Data
Posted - 02/06/2013 : 21:15:07
