GuruGPrasad (9/4/2012)

---

Thanks Lynn Pettis

Max column length may vary.

And your code

select

country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;

does not suit my needs.

Please find the attachment

Regards

Guru

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