title: How can I set up a simple calculated field in SQL Server?
body: <p>I have a table with several account fields like this:</p>
  
  <pre><code>MAIN_ACCT
  GROUP_ACCT
  SUB_ACCT
  </code></pre>
  
  <p>I often need to combine them like this:</p>
  
  <pre><code>SELECT MAIN_ACCT+'-'+GROUP_ACCT+'-'+SUB_ACCT
  FROM ACCOUNT_TABLE
  </code></pre>
  
  <p>I'd like a calculated field that automatically does this, so I can just say:</p>
  
  <pre><code>SELECT ACCT_NUMBER FROM ACCOUNT_TABLE
  </code></pre>
  
  <p>What is the best way to do this?</p>
  
  <p>I'm using SQL Server 2005.</p>