John Campbell wrote:
In sql, every comparison to NULL, yields another NULL. That is why 'SELECT * WHERE foo = NULL' doesn't do what you might expect. In fact that query is guaranteed to always return zero rows.
which is why the correct syntax for such a select would have to be 'SELECT * [FROM table] WHERE foo IS NULL' rather than '= NULL'
-- ================= Michael Southwell Vice President, Education NYPHP TRAINING: http://nyphp.com/Training/Indepth _______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show_participation.php
