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
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 4, 2012 at 3:43 pm
#1533558
Two things. One, your code would simply look like this:
select
country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;
Two, be sure to use a fixed space font, not a proportional font, to display the output.