A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Functions: Mathematical Functions

power()

The mathematical function power() returns the value to the power of "power" for the parameter "number".

Syntax of the Mathematical Function power()

    power(number, power)
    

The parameter "number" of the Mathematical Function power()

number
The parameter "number" is a placeholder for values, which must be of the datatype numeric. Additionally, the parameter "number" recognises every other datatype, which can be converted into on of the required datatypes with the help of implicit conversion.

power
The parameter "power" is a placeholder for values which must be one of the datatypes numeric, approximate numeric or money Additionally, the parameter "power" recognises every other datatype, which can be converted into one of the required datatypes with the help of implicit conversion.

Example for the Mathematical Function power()

    select power(2, 4)
go
-----
16

Returns 16.

See also:

ASE T-SQL - Aggregate Functions,
Mathematical Functions,
abs(),
acos(),
asin(),
atan(),
atn2(),
ceiling(),
cos(),
cot(),
degrees(),
exp(),
floor(),
log(),
log10(),
pi(),
radians(),
rand(),
round(),
sign(),
sin(),
sqrt(),
tan().