Thanks for the Reply. I have already tried with converting the real into decimal before converting to Varchar
Declare @real real
Set @real=Input
print Round(Convert(varchar(30),Convert(Decimal(15,7),@real)),2)
If Input = 19.005, expected Result is 19.01. but i cant able to reproduce the same. Actual result is 19
i can able to achieve the result when Input = 19.0051( Result is 19.01).