IMSUB

Updated 2024-03-13 20:07:52.733000

Syntax

SELECT [westclintech].[wct].[IMSUB] (
  <@inumber1, nvarchar(4000),>
 ,<@inumber2, nvarchar(4000),>)

Description

Use the scalar function  IMSUB to return the difference between 2 complex numbers in x + yi or x + yj text format. The difference between 2 complex numbers is computed as:

(a+bi)-(c+di)=(a+c)+(b-d)i

Arguments

@inumber2

is the second value used in evaluating the function. @inumber2 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 be converted to float and yi (or yj) is an imaginary number, where the y part can be converted to float.

@inumber1

is the first value used in evaluating the function. @inumber1 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 be converted to float and yi (or yj) is an imaginary number, where the y part can be converted to float.

Return Type

nvarchar(4000)

Remarks

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

Examples

select wct.IMSUB('7+24i', '6-25i');

This produces the following result.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"1+49i"}]}