title: How to create a view with different column names than source table
body: <p>I have a table that stores email data.  The challenge that I have is that some of the column names use MSSQL Reserved Words such as To and FROM.</p>
  
  <p>I've place brackets around the column names and my Query works fine in Query Designer, but the challenge is I'll be calling it from ASP.Net.  Bracket syntax in ASP.Net indicate it should inject data in place of the brackets.</p>
  
  <p>To avoid all of this I want to create a View.  How do I change the column names in the View to avoid Reserved Words?</p>
  
  <pre><code>SELECT        PortalID, [To], [From], Subject, Body, CreatedOnDate, CreatedByUserID
  FROM            dbo.CoreMessaging_Messages
  </code></pre>