^ (exponentiation)
The exponentiation operator (^) returns
the result of raising the first argument to the power of the second.
Syntax
X^Y
Input
| Argument | Type | Description |
|---|---|---|
X |
any numeric type | A scalar expression or column expression |
Y |
any numeric type | A scalar expression or column expression |
Return Value
Returns a numerical value corresponding to the result of raising X to the
power of Y.
The data type of the result is decimal.
If X and/or Y is N/A, the result is N/A.