• 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).