title: Stored procedure not null and not empty or space
body: <p>I try to use stored procedure in my project.However i have question about null and empty.    </p>
  
  <pre><code>ALTER PROCEDURE [dbo].[SP_EMAIL_LIST]
  AS
  BEGIN
  SELECT *
  FROM CUSTOMER
  WHERE
  EMAIL_ADRESS IS NOT NULL       
  END
  </code></pre>
  
  <p>I used where clause for avoid getting values null or empty values however i still get null values.</p>
  
  <p>How can i get email adress values if not null and not empty ?</p>