title: SSMS 2016: Exporting query results in CSV where fields are enclosed into delimiting quotes.
body: <p>I have a missing option <strong>quote strings containing list separators when saving .csv results</strong> in SSMS 2016. Seems like this option was eliminated in this version of SSMS.</p>
  
  <p>I need to export query results in CSV file (i.e., Comma Separated Variable file) is an UTF-8/ASCII text file in which records have a variable length and end with a carriage return and line feed. Fields are explicitly delimited with a comma. It is recommended that all fields are enclosed into delimiting quotes. The delimiting quotes are mandatory for those fields that are expected to contain a list of codes separated by comma.</p>
  
  <p>I am able to export the results into CSV file BUT it is missing the delimiting quotes. e.g. I have following output </p>
  
  <pre><code>Aguilar,F,03191970,H,700,699,240,S
  </code></pre>
  
  <p>which is supposed to be </p>
  
  <pre><code>Aguilar,F,03191970,H,"700,699,240",S
  </code></pre>
  
  <p>Not sure if there is a better way to accomplish the same. Please advise. </p>