| title | EXP (SSIS Expression) | ||
|---|---|---|---|
| description | EXP (SSIS Expression) | ||
| author | chugugrace | ||
| ms.author | chugu | ||
| ms.date | 03/01/2017 | ||
| ms.service | sql | ||
| ms.subservice | integration-services | ||
| ms.topic | concept-article | ||
| helpviewer_keywords |
|
[!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.
EXP(numeric_expression)
numeric_expression
Is a valid numeric expression.
DT_R8
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.
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.