Using <> or != on a NULL
582145Nov 22 2007 — edited Dec 7 2007Hi,
This is probably a very easy question..
When I try to SELECT some rows based on tableA.col1 <> tableB.col1, I get less rows than expected back. I think it's because some of the tableA.col1 are NULL and tableB.col2 have values.
Is there a way to check for equality w/out having to use IS NULL and IS NOT NULL?
Thanks,