title: Force NULL to be a string in SELECT NULL FROM Table
body: <p>I am migrating some views and finally returning null for some columns for backward compatibility. However, when I change the column name to <code>NULL AS [MyName]</code>, the column becomes an <code>INT</code>.  </p>
  
  <p>How to force the [MyName] column to stay a <code>String</code>?</p>
  
  <pre><code>SELECT NULL AS [MyName] 
  FROM [Table]
  </code></pre>
  
  <p>This is for SQL Server.</p>