Using the POWER and EXP Exponential Functions
From Accessing and Changing Relational Data
Using the POWER and EXP Exponential Functions
The POWER function returns the value of the given numeric expression to the specified power. POWER(2,3) returns 2 to the third power, or the value 8. Negative powers can be specified, so 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 given numeric expression. Therefore, if the result has three decimal places, the number to raise to a given power must have three decimals, too.
The EXP function returns the exponential value in scientific notation of the given float expression. So, with a value of 198.1938327, the EXP function returns a value of 1.18710159597953e+086.
SELECT EXP(198.1938327)