Query - General - Round off a Real Value without Truncation

Hi,
I want to perform the following steps
1. Convert the real number into a character.
2. Convert the resulting character to a decimal.
3. Round the value at the N+1 th place.

My requirement is
When n=2
I want to round 18.005 to 18.01 or 18.0049 to 18.00(at 100th place)

when i try with

Declare @real real
Set @real=18.005
print Round(Convert(Decimal(15,7),Convert(varchar(30),@r eal)),2)

i can able to get the result until i get some indefinite real value like -4.8892562E-08.
so when i try the same logic, i am getting a conversion error(Error converting data type varchar to numeric.).

I noticed when i convert a real value of 19.05 to decimal(15,7) some of the digits are gets truncated. i am getting 19.0049991608 as result.
Please help me to get the problem resolved. thanks in advance

Are you taking this approach because the number of decimal places you need to round to is variable? If that is not the case you can simply use decimal(15,2) for two decimal places and that will solve your problem; although I have a hunch you want something more variable.

So I tried working with your example using float instead of real and here is what I did:
This results in 18.01 by the way, and using 19.05 results in... you guessed it 19.05. You'll want to do more testing, but I was also able to cast 19.05 to decimal(15,7) and I got 19.0500000 using float instead of real.

Give that a try and let me know if it works for you

Hi,

I hope that the below query will be useful for you


Declare
@real real,@n int, @sqlstr varchar(8000);
Set @real=18.005;
set @n = 1;
set @sqlstr = 'Select cast(' + cast(@real as varchar)+' as decimal (5,' + cast(@n as varchar)+'))'
exec (@sqlstr)


Thanks & Regards
Sakthimeenakshi.S