title: T-SQL Format integer to 2-digit string
body: <p>I can't find a simple way to do this in T-SQL.</p>
  
  <p>I have for example a column (SortExport_CSV) that returns an integer '2' thru 90.
  If the stored number is a single digit, I need it to convert to a 2 digit string that begins with a 0.
  I have tried to use CAST but I get stuck on how to display the style in the preferred format (0#)</p>
  
  <p>Of course it is easy to do this on the front end (SSRS, MSAccess, Excel, etc) but in this instance I have no front end and must supply the raw dataset with the already formatted 2 digit string.</p>