GuruGPrasad (9/4/2012)
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
You do know that the longest country in your table is 53 characters long, right?