This blog shows how to use the Mathematical function POWER to get the nth power of a value in SQL

Example:

SELECT POWER(10,2) PoweredResult

The result would be as 100