Pls try this

DECLARE @Num4 AS DECIMAL(10,4)

SET @Num4 = 1234.9876

SELECT STR(@Num4,Len(@Num4),2)