title: How to replace empty spaces with NULL
body: <p>I have a column in sql server 2012 which contain white spaces. I want to replace these empty spaces with NULL. I have written the following query but its not working.</p>
  
  <pre><code>SELECT replace(COLUMN1, '',NULL) 
  FROM Orders;
  </code></pre>
  
  <p>How to achieve the above functionality. Thanks in advance.</p>