Hi Madhu,

When my value is like 1567987.4699987 i got the output as

1567987.47 which is actually rounding off the value

DECLARE @Num4 AS DECIMAL(10,4)

SET @Num4 = 1567987.4699987

SELECT LEFT(CONVERT(VARCHAR(20),@Num4),CHARINDEX('.',CONVERT(VARCHAR(20),@Num4))+2)

And the values specified above are just examples not real values.

Hope i am clear in my explaining the problem.