comparing data with NULL values

From: <lionroar_at_my-dejanews.com>
Date: Mon, 03 May 1999 21:15:34 GMT
Message-ID: <7gl3li$m3u$1@nnrp1.dejanews.com>

I'm having trouble comparing fields stored in variables if any of the variables has a NULL value. Basically when I say:

IF X = Y THEN
Z;
END IF; ... if one of the 2 values contains a NULL value and the other doesn't, then the condition passes and Z is processed.... but the 2 values are NOT equal .. one is NULL?? If anyone can help can you send me an email at brian_connor_at_gmacm.com

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 03 1999 - 16:15:34 CDT