EXP (T-SQL)

Returns the exponential value of the given float expression.

Syntax

EXP(float_expression)

Arguments

float_expression

Is an expression of type float.

Return Types

float

Examples

This example declares a variable and returns the exponential value of the given variable (378.615345498) with a text description.

DECLARE @var float

SET @var = 378.615345498

SELECT 'The EXP of the variable is: ' + CONVERT(varchar,EXP(@var))

GO

Here is the result set:

The EXP of the variable is: 2.69498e+164                  

(1 row(s) affected)

See Also