Hi everybody,
I need to convert float data type to string, but I don't want round the data. For example:
MyData = .3999999 or =.5
I want to have
MyResult = .399 or .500 (with no round!)
I tried STR, CONVERT, CAST function and combination of this function and LEFT, LEN finction and etc. Cannot find the solution. Sometimes it's giving me a good looking result when I used MyData = .3999999 but it's not working for MyData = .5
Any helt will be appreciate,
Miriam
I need to convert float data type to string, but I don't want round the data. For example:
MyData = .3999999 or =.5
I want to have
MyResult = .399 or .500 (with no round!)
I tried STR, CONVERT, CAST function and combination of this function and LEFT, LEN finction and etc. Cannot find the solution. Sometimes it's giving me a good looking result when I used MyData = .3999999 but it's not working for MyData = .5
Any helt will be appreciate,
Miriam