POWER function [Numeric]

Function

Calculates one number raised to the power of another.

Syntax

POWERnumeric-expression1, numeric-expression2 )

Parameters

numeric-expression1 The base.

numeric-expression2 The exponent.

Example

The following statement returns the value 64:

SELECT Power( 2, 6 ) FROM iq_dummy

Usage

Raises numeric-expression1 to the power numeric-expresson2.

Standards and compatibility