title: Combining INSERT INTO & SELECT with a function
body: <p>I need to reverse the values in a column and add six trailing zeros. I have been using variations of the following, trying to export into another table, then pull back in etc but I am failing.</p>
  
  <pre><code>INSERT INTO #TempTable (accountnbr2)
       SELECT Accountnbr, REVERSE(AccountNbr)+'000000' AS Backwards
  FROM WhateverID
  </code></pre>
  
  <p>I'm halfway there, I just can't get the output of the SELECT statement back into the AccountNbr field. What is the best method to do this? </p>