Try this

SELECT RIGHT('000000' + CAST(Col1 as VARCHAR), 6) + RIGHT('000' + CAST(Col2 as VARCHAR), 3)

Hope this helps.

Edit:

Just saw this was an older post lol