Re: Can someone tell me why this fails?

2006-01-04 Thread Ed Reed
Thanks Peter, for the quick reply. >>> Peter Brawley <[EMAIL PROTECTED]> 1/4/06 11:44 AM >>> Ed, >Can someone tell me why this fails? I'm using v4.1.11 >Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1), >'WRONG'

Re: Can someone tell me why this fails?

2006-01-04 Thread Peter Brawley
Ed, >Can someone tell me why this fails? I'm using v4.1.11 >Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1), 'WRONG') >I would expect a result of 2. NULL is neither equal nor unequal to anything including itself. To get the

Can someone tell me why this fails?

2006-01-04 Thread Ed Reed
Can someone tell me why this fails? I'm using v4.1.11 Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1), 'WRONG') I would expect a result of 2. - Thanks