title: Convert multiple columns (year,month,day) to a date
body: <p>I've got a few columns that I'm trying to convert to one, but I'm having some issues here.</p>
  
  <p>The problem is that the Month or day can be single digit, and I keep losing that <code>0</code>.</p>
  
  <p>I'm trying it on a view first before I do the conversion, but can't even get the three columns to give a string like this <code>20090517</code>.</p>
  
  <p>Any ideas? <code>CAST</code> and <code>RIGHT</code> doesn't seem to be doing it for me.</p>