When converting a value from a Float to a varchar, it's rounding. For example, I have a value, $35140.08, and when converted to a varchar it becomes 35140.1. My ultimate goal is I need to present the value (which is a float datatype) with 2 decimal places with no decimal point, ie: 3514008.
SELECT REPLACE(CAST(CAST('35140.08' as FLOAT) as VARCHAR(255)),'.','') as MyValue
Any ideas? I tried FLOOR, STR and neither helped.