SQL Server ERF Function

Updated 2024-03-14 14:28:03.303000

Description

Use the scalar function ERF to calculate the error function. The error function is defined by:

\operatorname{erf}z=\frac{2}{\sqrt\pi}\sum_{n=0}^\infty\frac{(-1)^nz^{2n+1}}{n!(2n+1)}

Syntax

SELECT [westclintech].[wct].[ERF] (
   <@z, float,>)

Arguments

@z

is the value at which to evaluate the function. @z is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Examples

select wct.ERF(.75);

This produces the following result.