DELTA

Updated 2023-11-08 20:40:40.610000

Syntax

SELECT [westclintech].[wct].[DELTA] (
  <@Number1, float,>
 ,<@Number2, float,>)

Description

Use the scalar function DELTA to test whether two values are equal.

Arguments

@Number1

is the first number. @Number1 is an expression of type float or of a type that can be implicitly converted to float.

@Number2

is the second number. @Number2 is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Remarks

If @Number1 <> @Number2 then DELTA returns a one (1), otherwise DELTA returns a zero (0).

Examples

select wct.DELTA(5, 4);

This produces the following result.

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

select wct.DELTA(wct.IMABS('5+12i'), 13);

This produces the following result.

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