title: Oracle Documentation NOT NVL
body: <p>I'm doing some converting from Oracle to MSSQL and I was reading a guide by Oracle on <a href="http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apb.htm#i634543" rel="nofollow">B Supported SQL Syntax and Functions</a>. </p>
  
  <p>I noticed it was stated that there is a NOT NVL function (and its MSSQL equivalent was IS NOT NULL). </p>
  
  <p>I'm compiling a list for my colleagues so we can have a one-stop resource for syntax and supported functions, am I correct in assuming that NOT NVL works like so:</p>
  
  <blockquote>
    <p>There are 3 columns, name, location, loves_marmite</p>
    
    <p>Andrew | UK | Yes</p>
  </blockquote>
  
  <p>NOT NVL(loves_marmite, 'Nope')</p>
  
  <p>So the data displayed would be:</p>
  
  <pre><code>Andrew | UK | Nope
  </code></pre>
  
  <p>I just don't get why it would be listed as an Oracle Function when it's just a logic issue, and what's more is that Oracle has <strong>IS NULL</strong> and <strong>IS NOT NULL</strong>. </p>
  
  <p>I'm sorry I'm just looking for some clarification before I pass this document on to my colleagues. </p>
  
  <p><strong>EDIT :</strong>  If possible would someone have a comprehensive list of function and syntax differences between the two platforms?</p>