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