title: Convert Empty string into NULL when data insert into table from another table
body: <p>I am stuck on inserting data from one table into another table and exporting data into csv file using <code>bcp</code>. The problem is that the csv text file contains <code>null</code> instead of '' empty string.</p>
  
  <p>When I insert data into a table from another table the empty string column is treated as a <code>NULL</code>. Doing the <code>bcp</code> command generate correct file.</p>
  
  <p>I am using this command to export bcp</p>
  
  <pre><code>bcp ClientReportNewOrder out "D:\Temp\Neeraj\TestResults\oOR.txt" -c -t"," -r"\n" -S"." -U"sa" -P"123"
  </code></pre>
  
  <p>and  this for insert data into table</p>
  
  <pre><code>insert into ClientReportNewOrder
      select * from ClientReportNewOrder_import
  </code></pre>