IMABS

Updated 2024-03-13 15:29:26.827000

Syntax

SELECT [westclintech].[wct].[IMABS] (
   <@inumber, nvarchar(4000),>)

Description

Use the scalar function IMABS function to calculate the absolute value of a complex number in the x + yi or x + yj format. The absolute value of a complex number is calculated as:

|Z|=\sqrt{x^2+y^2}

where:z = x + yi

Arguments

@inumber

is the value at which to evaluate the function. @inumber is an expression of type varchar or of a type that can be implicitly converted to varchar and must be in the format x + yi or x + yj, where x is a real number that can converted to float and yi (or yj) is an imaginary number, where the y part can be converted to float.

Return Type

float

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number

IMABS(@inumber) = SQRT(power(IMREAL(@inumber), 2)+power(IMAGINARY(@inumber, 2)))

Examples

select wct.IMABS('7+24i');

This produces the following result.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"25"}]}

select SQRT(power(wct.IMREAL('7+24i'), 2) + power(wct.IMAGINARY('7+24i'), 2));

This produces the following result.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"25"}]}