title: Select Query for the fixed length
body: <p>I have an table called customer where i am selecting few columns and making its fixed length,where i need to send the values to SSIS packages for an fixed length output and is written in a text file</p>
  
  <pre><code>customerID:10
  Mobilenumber:11
  Emailaddress:256
  
  select customerID,mobilenumber,Emailaddress from customer 
  </code></pre>
  
  <p>I want to make sure my customerID is always length of 10, mobile number 11, emailaddress 256.</p>