title: Creating a new column based on another column in SQL Server
body: <p>Quick question - I want to create another column in SQL Server such as:</p>
  
  <p><strong>Original Table</strong></p>
  
  <pre><code>Type         Amount     LocNum
  Chocolate    15         WC-10202-01
  Banana       10         WC-35209-22
  Vanilla      5          WC-15815-15
  </code></pre>
  
  <p><strong>Ideal Table</strong> </p>
  
  <pre><code>Type         Amount     LocNum          LocNum2
  Chocolate    15         WC-10202-01     WC-10202
  Banana       10         WC-35209-22     WC-35209
  Vanilla      5          WC-15815-15     WC-15815
  </code></pre>