Login     Register

        Contact Us     Search

XLeratorDB/engineering Online Documentation

SQL Server DELTA function


 
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)


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service