Pow
Returns x raised to the power of y.
Numeric Pow(Numeric x, Numeric y)
The ^ operator
In expressions ^ is the bitwise exclusive-or operator, not exponentiation. Use Pow() to raise a number to a power.SELECT Pow(2, 10) as Result FROM SingleSELECT Pow(2, 10) as Result FROM Single