SQL Server/T-SQL/Data Type/float

Cast value to float

12>
13> SET NOCOUNT ON
14> DECLARE @float1 float
15> SET @float1 = CAST(POWER(10,9) as float)
16> SELECT @float1 * @float1 * @float1 * @float1 * 100 AS "Large Float value",
17>     FLOOR(LOG10(@float1 * @float1 * @float1 * @float1 * 100)
18>     + 1) AS "Number of digits"
19> GO
Large Float value        Number of digits
------------------------ ------------------------
  9.9999999999999998E+37                       39
1>
2>