• DECLARE @D DECIMAL(18,9)

     ,@S VARCHAR(20)

     ,@R VARCHAR(20)

    SET @D = 0.8333

    SET @S = CAST(@D AS VARCHAR(20))

    SET @r = REVERSE(SUBSTRING(@S, CHARINDEX('.', @S) + 1, 20))

    SELECT LEN(SUBSTRING(@R, PATINDEX('%[1-9]%', @r), 20))