I need to display country and currency_code in a single column.

select country + space(46-Len(country)) + CONVERT(varchar(max), currency_code ) from currency order by country

Afghanistan, Afghanis -AFN

Albania, Leke -ALL

Algeria, Algeria Dinars -DZD

Angola, Kwanza -AOA

Argentina, Pesos -ARS

Armenia, Drams -AMD

Regards

Guru