Converting FLOAT to VARCHAR
The conversion from a float datatype to varchar datatype can be fraught with peril! Lets take our fictional number 7555000001 which is helpfully stored in a float datatype. Now in the context of a telephone number we have an issue.