This topic has not yet been rated - Rate this topic

EXP (SSIS)

SQL Server 2005

Returns the exponent to base e of a numeric expression. The EXP function complements the action of the LN function and is sometimes referred to as the antilogarithm.

Syntax


EXP(numeric_expression)

Arguments

numeric_expression: Is a valid numeric expression.

Result Types

DT_R8

Remarks

The numeric expression is cast to the DT_R8 data type before the exponent is computed. For more information, see Integration Services Data Types.

The return result is always a positive number.

Examples

These examples apply the EXP function to positive and negative values and to zero.

EXP(74)

Returns 1.373382979540176E+32.

EXP(-27)

Returns 1.879528816539083E-12.

EXP(0)

Returns 1.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

EXP (SSIS)

Reference

Other Resources

Help and Information

Community Additions