title: SQLLDR and NULL Field detection in column to be imported
body: <p>SQLLDR and CTL file</p>
  <p>Got a CSV file to import.</p>
  <p>I want to specify in my CTL file to insert only into my table when I've got an empty value in a certain column in my CSV file. E.G  I want to upload only user's records who <strong>don't</strong> have a termination date.</p>
  <p>I've tried various options</p>
  <ul>
  <li>When TERMINATIONDATE = ''</li>
  <li>When TERMINATIONDATE = &quot;&quot;</li>
  <li>When TERMINATIONDATE = null</li>
  <li>When TERMINATIONDATE = 'null'</li>
  </ul>
  <p>It only works when I'm using</p>
  <ul>
  <li>When TERMINATIONDATE != ''
  then i get all my employees that have been terminated.
  But i want the opposite...</li>
  </ul>
  <p>Doesn't look like it's possible after all?</p>
  <p>my CTL file</p>
  <pre><code>OPTIONS (SKIP=1)
  LOAD DATA
  INFILE 'C:\temp\users.csv' 
  BADFILE 'C:\temp\users.bad'
  DISCARDFILE 'C:\temp\users.dsc'
  TRUNCATE
  INTO TABLE &quot;alawakaba&quot;.&quot;users&quot;
  When TERMINATIONDATE = ''
  FIELDS TERMINATED BY '|'
  OPTIONALLY ENCLOSED BY '&quot;'
  TRAILING NULLCOLS
  (
  ID,
  FIRSTNAME,
  LASTNAME,
  FUNCTION,
  DEPARTMENT,
  COSTCENTER,
  HIREDATE,
  Field8 FILLER,
  TERMINATIONDATE,
  LOCCODE
  )
  </code></pre>
  <p>(Column8 is just one I don't need so I'm skipping that)</p>