Transact-SQL Reference

EXP

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

CAST and CONVERT

float and real

Mathematical Functions

money and smallmoney