lm1189
asked on
Float Rounding when converted to varchar
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.
Any ideas? I tried FLOOR, STR and neither helped.
SELECT REPLACE(CAST(CAST('35140.08' as FLOAT) as VARCHAR(255)),'.','') as MyValueAny ideas? I tried FLOOR, STR and neither helped.
Lee
SELECT REPLACE(CAST(CAST('35140.0
declare @f as float
set @f = 35140.088888888888
SELECT CAST(CAST(@f * 100 as bigint) as VARCHAR(255)) as MyValue
set @f = 35140.088888888888
SELECT CAST(CAST(@f * 100 as bigint) as VARCHAR(255)) as MyValue
Like it...
Even simpler:
SELECT cast(35140.08 * 100 as bigint)
Even simpler:
SELECT cast(35140.08 * 100 as bigint)
:) I like simple
What if the value internally is: $35140.086?
Do you want to see 3514008 or 3514009?
Do you want to see 3514008 or 3514009?
When converting a value from a Float to a varchar, it's rounding.
Just as an aside and I am sure you have already figured this out, but float is an approximate numeric value and typically should not be used in business applications. Instead you should use numeric or money as they are fixed numeric types and therefore no rounding problems like this.
Just as an aside and I am sure you have already figured this out, but float is an approximate numeric value and typically should not be used in business applications. Instead you should use numeric or money as they are fixed numeric types and therefore no rounding problems like this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lm1189, Hi. Have we answered this question - could it be closed off?
ASKER
I tried multiple methods but all had rounding issues, I eventually had to conver to the Money datatype which resolved my issues.