title: Replace empty strings with null values
body: <p>I am rolling up a huge table by counts into a new table, where I want to change all the empty strings to <code>NULL</code>, and typecast some columns as well. I read through some of the posts and I could not find a query, which would let me do it across all the columns in a single query, without using multiple statements.</p>
  
  <p>Let me know if it is possible for me to iterate across all columns and replace cells with empty strings with null.</p>
  
  <p>Ref: <a href="https://stackoverflow.com/questions/3701812/convert-empty-space-to-null">How to convert empty spaces into null values, using SQL Server?</a></p>