Hi. i can able to get what i am expected when i use the below code

Declare @real Decimal(15,7)

Set @real=19.005

print ROUND(@real + CAST(0.5E * POWER(0.1E, 2) AS DECIMAL(15, 3)), 2, 1)

Output = 19.01

i am not able to predict the length of the digit after dot, it may vary. so the length of the decimal used while casting should not be hard-coded.

i cant able to supply the length at runtime like decimal(15,@n+1).

Thanks,

Idris Gani R