Home Forums SQL Server 2005 T-SQL (SS2K5) Round real Value withoot truncation RE: Round real Value withoot truncation
Randolph West
SSCommitted
Points: 1585
More actions
July 2, 2009 at 4:45 am
#1019024
You're going to run into that problem because of the rule for the floating point. How about converting to decimal(38,17) from real before trying to cast it out to a varchar?
Alternatively, do this in code.