How can I convert my float type to a varchar datatype.
When the number has more than 6 decimal places SQL rounds the decimal portion of the number. I haven't found a way to not lossin the precision.
IF I convert the float value to a numeric value, sometimes it converts it like this: 123.985899999
and it should be 123.9859.
Does anyone know something about this?