T-SQL FIxed-Width Output

Question

Is there a way to get SQL Server to output a string with a fixed width? For example

SELECT FixedWidth(cola, 7), FixedWidth(colb, 10) ...

That would output 2 strings with 7 and 10 characters wide repsectively? Something like

'test   ' 'foobar    '
'aabbb  ' 'hello     '
'foo    ' 'bar       '

Answer 1

  SELECT 
       CAST(cola as char(7)) as cola, 
       CAST(colb as char(10)) as colb ....