title: sqlcmd: reconciling -W and -Y
body: <p>I have an automated batch process that uses sqlcmd to pull data from a database and dump it into a text file. Many fields in that database are of type <code>varchar(max)</code>, Sqlcmd limits these fields to 256 characters unless I add something like <code>-y 0</code> to the flags in the sqlcmd call.</p>
  
  <p>This gives me the full text for fields larger than 256 characters, but it also adds a great deal of whitespace; the fields are padded to make each field as big as it could possibly be according to its data type, essentially giving me huge files with lots of padding and wasted space.</p>
  
  <p>I could fix this by adding <code>-W</code> to my sqlcmd flags, but this gives me an error saying that <code>-W</code> and <code>-y</code> are incompatible.</p>
  
  <p>Has anyone had this problem before? Thoughts on how to solve it?</p>