Database Programming: Did You Know IN Can Do This?

Ward Pond, one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a discussion internally on concerning the capabilities of the IN operator:

Were you aware of that ? :-)

Be also aware of the facts that NULL can change the expected results !