title: Oracle empty string/NULL
body: <p>I have to write an SQL SELECT statement which is valid for MS SQL Server and Oracle. I have to work with old customer databases, so I cannot change anything in the db design...</p>
  
  <p>Problem is that the table has a nullable column 'project' which is a varchar that is in some cases filled with an empty string - which is translated by oracle to NULL.
  So how do I select all columns that have an NON empty 'project'?</p>
  
  <pre><code>WHERE project IS NOT NULL                   works for oracle
  WHERE project &lt;&gt; ''                         works for MS
  WHERE project IS NOT NULL AND project &lt;&gt; '' works for MS, but not for Oracle
  </code></pre>
  
  <p>Thanks,
  Marko</p>