GuruGPrasad (9/4/2012)
Thanks Lynn PettisMax 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
What attachment, and I just followed what you posted:
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