ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

POWER function [Numeric]

Function 

Calculates one number raised to the power of another.

Syntax 

POWER ( numeric-expression-1, numeric-expression-2 )

Parameters 

numeric-expression-1    The base.

numeric-expression-2    The exponent.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value 64.

SELECT Power( 2, 6 )