The SQL IS NOT NULL condition is used to test for a NOT NULL value in SELECT, INSERT, UPDATE, or DELETE ...
www.techonthenet.com