ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

EXP

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.