title: Using IS NOT NULL for multiple columns
body: <p>I want to check for the is not null constraint for multiple columns in a single SQL statement in the <code>WHERE</code> clause, is there a way to do so?
  Also I don't want want to enforce the <code>NOT NULL</code> type constraint on the column definition.</p>
  
  <pre><code>SELECT * FROM AB_DS_TRANSACTIONS 
  WHERE FK_VIOLATION IS NULL 
  AND TRANSACTION_ID NOT IN(
      SELECT distinct TRANSACTION_ID FROM AB_TRANSACTIONS) 
  AND COUNTRY_ID IS NOT NULL 
  AND GEO_CUST_COUNTRY_ID IS NOT NULL 
  AND INVOICE_DATE IS NOT NULL 
  AND ABB_GLOBALID IS NOT NULL 
  AND SALES_ORG_ID IS NOT NULL 
  AND DIST_ID IS NOT NULL 
  AND CUSTOMER_ID IS NOT NULL 
  AND REPORT_UNIT_ID IS NOT NULL 
  AND CURR_INVOICE IS NOT NULL 
  AND DIVISION_CODE IS NOT NULL 
  </code></pre>
  
  <p>So instead of using IS NOT NULL again and again I want to simplify things</p>