Function operator DELTA in Query designer

[Former Member]

Hi Expert.

I found the operator DELTA is used in our query designer like below:

(delta(object1)*object2+object1)

could you please give me some info on it? thank you in advance!

[Former Member]

hi

Delivers the value 1 if the <Expression> is 0, otherwise 0.

The function is identical to the NOT operator and should no longer be used.

eg:delta(exp is 0)2+0xxx

1*2+1=3

Regards,

Sai.

[Former Member]

eg:delta(exp is 0)2+0xxx

1*2+1=3

one question: why 0xxx=1 ? My understanding is 12+0=2, pls let me know if I missed sth.

Thank you!

[Former Member]

Hi Yaodan

The DELTA(<Expression>)

Returns value 1 if the <expression> is 0, else it returns 0.

The DELTA function is identical to the NOT operator and should no longer be used.

Regards,

Ninad

[Former Member]

I am not sure my understanding is right or not.

if object1 equal 0, the final result= object2

if object1 not equal 0 , the final result=object1

Edited by: YAODAN on Jun 8, 2011 7:46 AM

[waqar_ahmed]

HI,

DELTA(<Expression>) Returns value 1 if the <expression> is 0, otherwise 0.

This function is identical to the NOT operator and should no longer be used.

Regards,

ray

[Former Member]

Hi,

In order to supress 0 value in resut set....