SELECT * FROM Foobar WHERE Val = NULL;
I'm admittedly still learning SQL, but I'm very surprised by this.
The query should be:
SELECT * FROM Foobar WHERE Val IS NULL;