Using the POWER and EXP Exponential Functions

The POWER function returns the value of the specified numeric expression to the specified power. POWER(2,3) returns 2 to the third power, or the value 8. Negative powers can be specified. Therefore, POWER(2.000, -3) returns 0.125. Notice that the result of POWER(2, -3) is 0. This is because the result is the same data type as the specified numeric expression. Therefore, if the result has three decimal places, the number to raise to a specific power must have three decimals, too.

The EXP function returns the exponential value in scientific notation of the specific float expression. Therefore, with a value of 198.1938327, the EXP function returns a value of 1.18710159597953e+086, for example:

SELECT EXP(198.1938327)

Here is the result set.

----------------------

1.18710159597953E+86

(1 row(s) affected)

See Also

Other Resources

EXP (Transact-SQL)
POWER (Transact-SQL)
Mathematical Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance