Operator: ^
The Power operator (or exponentiation) ^
is used to calculate a number raised to a given power.
There is also a Power Function that can be used: Pow(value, power)
.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number that is the result of number1
raised to a given power (number2
).
If any of the operands is an unknown-number, the result is unknown. If any of the operands is not a number, expression editor yields a type mismatch warning.