/* Comparing value to NULL */  

SELECT  *  FROM  address
WHERE  street2  IS  NULL;

SELECT  *  FROM  address
WHERE  street2  is  not null;