XLeratorDB/engineering Online Documentation
Updated: 27 August 2010
Use DELTA to test whether two values are equal.
Syntax
SELECT [wctEngineering].[wct].[DELTA] (
<@Number1, float,>
,<@Number2, float,>)
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 Types
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
----------------------
0
(1 row(s) affected)
select wct.DELTA(wct.IMABS('5+12i'), 13)
This produces the following result
----------------------
1
(1 row(s) affected)