Home Forums SQL Server 2008 SQL Server 2008 - General Equals space between two string when concatenate two columns RE: Equals space between two string when concatenate two columns
GuruGPrasad
SSCommitted
Points: 1768
More actions
September 4, 2012 at 3:54 pm
#1533561
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