==operator in SQL that yields true if both operands are either
nullor have the same value?
Here's the truth table for the
This has some implications. The statement
I suspect that in most cases this is not what the author of such a statement wants. Therefore, they will rewrite the query so:
Now, if there were a
== operator with this truth table:
Maybe I am all wrong and there is such a thing somewhere. If you know of such an operater in any database product, please let me know!