SQL Server/T-SQL Tutorial/Math Functions/Power

POWER returns a number (input_x) raised to the power of a number (input_y).

   <source lang="sql">

4> 5> 6> SELECT 1464*(1/POWER((1+.10),4)) 7> GO

---

    1002.739726027397260273972602739726

(1 rows affected) 1></source>

SELECT POWER(10,2) Result

   <source lang="sql">

33> 34> SELECT POWER(10,2) Result 35> GO Result

---

       100

(1 rows affected)</source>