title: SQL build column name from results in query
body: <p>I have a table with 60 columns:
  <code>[Actual_Deb01],[Actual_Deb02],[Actual_Deb03],.......,[Actual_Deb60]</code></p>
  
  <p>one of the columns in the queries is period and I only want to fetch the actual_debt for the period.</p>
  
  <p>how can I use the period to build the actual_deb col name I want to fetch.
  something like:</p>
  
  <pre><code>SELECT  Actual_Deb04],
          period,
          ['Actual_Deb'+period]
  FROM table
  </code></pre>
  
  <p><code>period</code> in the above is <code>03</code> so I want the query to effectively be:</p>
  
  <pre><code>SELECT  [Actual_Deb04],
          period,
          [Actual_Deb04]
  FROM table
  </code></pre>
  
  <p>Can i do this in the query syntax?</p>
  
  <p>Thanks in advance as always, 
  R</p>