title: Sqlcmd trailing spaces in output file
body: <p>Here is my simplified scenario: </p>
  
  <p>I have a table in SQL Server 2005 with single column of type <code>varchar(500)</code>. Data in the column is always 350 characters in length.</p>
  
  <p>When I run a select on it in SSMS query editor, copy &amp; paste the result set in to a text file, the line length in the file is 350, which matches the actual data length.</p>
  
  <p>But when I use <code>sqlcmd</code> with the <code>-o</code> parameter, the resulting file has line length 500, which matches the max length of <code>varchar(500)</code>. </p>
  
  <p>So question is, without using any string functions in <code>select</code>, is there a way to let <code>sqlcmd</code> know not to treat it like <code>char(500)</code> ?</p>