Convert float to varchar
Posted on 2004-10-07
I need to convert a float datatype to a varchar datatype. Right now I use convert(varchar, myFloatField). This works, however, I get the value with the exp format. I don't want this. If the varchar value is -1277739.244272, I don't want the converted float value of -1.27774e+006, I want the float value of -1277739.244272. What am I doing wrong?
(I can't use the exp value b/c this field gets DTS'ed to Oracle...messy at best)