POWER Function [Numeric]

Calculates one number raised to the power of another.

Syntax

POWER ( numeric-expression1, numeric-expression2 )

Parameters

Parameter

Description

numeric-expression1

The base.

numeric-expression2

The exponent.

Returns

DOUBLE

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

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Compatible with Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions