SQL Server EXP() Function

Summary: in this tutorial, you will learn how to use the SQL Server EXP() function to calculate the exponential value of a number.

Introduction to SQL Server EXP() function #

The EXP() function is a math function that allows you to calculate the exponential value of a specified number.

Here’s the syntax for the EXP() function:

EXP(n)Code language: SQL (Structured Query Language) (sql)

In this syntax:

• The n is a float or a value that can implicitly converted to a float.

The EXP() function returns eⁿ where e is approximately equal to 2.71828182845905. If n is NULL, then the EXP() function returns NULL.

SQL Server EXP() function examples #

Let’s take some examples of using the EXP() function.

1) Basic EXP() function examples #

The following example uses the EXP() function to find the exponential value of 1:

SELECT EXP(1) result;Code language: SQL (Structured Query Language) (sql)

Output:

result
----------------
2.71828182845905

(1 row affected)Code language: SQL (Structured Query Language) (sql)

The following statement uses the EXP() function to calculate the exponential value of 5:

SELECT EXP(5) result;Code language: SQL (Structured Query Language) (sql)

Output:

result
-----------------
148.413159102577Code language: SQL (Structured Query Language) (sql)

Summary #

• Use the EXP() function to calculate the exponential value of a number.