IS NOT NULL

Retrieves rows where information is not null or does exist.

 

Example:

Select customer_address from customers where customer_address is not null