exp-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
EXP (SSIS Expression)	EXP (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	exponential functions EXP function

EXP (SSIS Expression)

[!INCLUDEsqlserver-ssis]

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.

Expression 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.

See Also

LOG (SSIS Expression)
Functions (SSIS Expression)