Returns expression1 raised to the power of expression2.

Syntax

POWER ( expression1 , expression2 )

Notes

  • expression1 must evaluate to a numeric data type.
  • expression2 must evaluate to an exact numeric data type.

Example

This example illustrates the POWER function, raising ‘3' to the second power:

SELECT POWER ( 3 , 2) '3 raised to the 2nd power' 
     FROM SYSPROGRESS.SYSCALCTABLE;