title: Append character in front of a number + varchar
body: <p>I have a table named Table1 which has a varchar, named Col1. I want to create a Table2 and add a leading "0" in front of the contents of Col1.</p>
  
  <p>How can I add a zero character to the front of a varchar? I have tried several ways but none seems to work.</p>