title: How to add a result column into my table?
body: <p>I am doing data cleaning practice in SSMS. I made a mock postcode table which needs to be cleaned:</p>
  
  <p><img src="https://i.stack.imgur.com/4ii3X.png" alt="enter image description here"></p>
  
  <p>Then I used SUBSTRING to grab the first half and second half:</p>
  
  <pre><code>SELECT SUBSTRING(post_code,1,3)
  FROM PostCode;
  
  SELECT SUBSTRING(post_code, LEN(post_code)-2,LEN(post_code))
  FROM PostCode
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/gwQXE.png" alt="enter image description here"></p>
  
  <p>For the next step, I am trying to add the 2 columns into my table then I can combine them together.  How should I do that?</p>
  
  <p>Thank you very much for and help!</p>