title: T-SQL FIxed-Width Output
body: <p>Is there a way to get SQL Server to output a string with a fixed width? For example</p>
  
  <pre><code>SELECT FixedWidth(cola, 7), FixedWidth(colb, 10) ...
  </code></pre>
  
  <p>That would output 2 strings with 7 and 10 characters wide repsectively? Something like</p>
  
  <pre><code>'test   ' 'foobar    '
  'aabbb  ' 'hello     '
  'foo    ' 'bar       '
  </code></pre>