title: Convert number to varchar in SQL with formatting
body: <p>Is there a way in T-SQL to convert a TINYINT to VARCHAR with custom number formatting?
  For instance, my TINYINT has a value of 3 and I want to convert it to a VARCH of 03, so that it always shows a 2 digit number.</p>
  
  <p>I don't see this ability in the CONVERT function.</p>