title: SQL "IS NOT NULL" compensation for SAP HANA SQLScript
body: <p>Actually I tried to run a <code>is null</code> SQL Statement on a SAP HANA Database using the SAP HANA Studio. This does not work because SQLScript has no <code>is not null</code> or <code>is null</code> function. My statement looks like:</p>
  
  <pre><code>Select *
  From MSEG
  Where KDAUF is null
  </code></pre>
  
  <p>Unfortunately it does not work. Does anybody know an alternative approach which is practicable using SAP HANA SQLScript? On the internet I found a hint to either use <code>NULLIF</code> or <code>COALESCE</code>. But I neither know how to use this function nor to adapt it to a working <code>WHERE</code> condition.</p>