title: How to do left align data in SQL Server 2008?
body: <p>I want to generate a text file with data by executing a procedure.
  But while generating text file, next or previous column value should not enter into other column value. Please see the below EX for more details.</p>
  
  <h2>Example</h2>
  
  <p>We have 2 columns of type <code>Varchar(5)</code> in a table. I want to generate a file with this data.
  So 5 characters will be allowed for each column.</p>
  
  <p><strong>Case 1:</strong> If first column is having 5 characters data(ex:'qwert'), we will get the data and second column value will come beside this. No problem. it works fine.</p>
  
  <p><strong>Case 2:</strong> If first column is having 3 characters data(ex:'asd'), we will get this but second column value should not enter into 4th position of 1st column value in the text file. if the data of the 1st column is &lt; 5 character, it should print and it should print remaining as blanks.</p>
  
  <p>Note: No delimiter required in text file.</p>