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 result you expect, write
Select IF(((Select 1+1) IS NOT Null) and ((Select 1+1) <> 0), (Select
1+1), 'WRONG');
PB
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 1/3/2006
