Yes, thanks to Hugo for the detailed explanation. I agree with those who say that the Microsoft documentation could use Hugo's addition!

I think the following queries show the switchover point where the REAL number is returned as 100.

-- Num1 = 99.99999

CREATE TABLE #QotD ( Num1 REAL, Num2 FLOAT );

INSERT INTO #QotD

VALUES ( 99.9999961, 99.99999999997 );

SELECT *

FROM #QotD;

DROP TABLE #QotD;

-- Num1 = 100

CREATE TABLE #QotD ( Num1 REAL, Num2 FLOAT );

INSERT INTO #QotD

VALUES ( 99.9999962, 99.99999999997 );

SELECT *

FROM #QotD;

DROP TABLE #QotD;

Thanks again.

- webrunner