title: SSMS: Pipe Delimited output
body: <p>I need to output the results from a query to a pipe delimited file.</p>
  
  <p>I followed these instructions:</p>
  
  <blockquote>
    <p>Tools--> Options --> Query Results --> Sql Server --> Results to Text.
    Change output format from Tab Delimited to Custom Delimited.
    Put a Pipe in the Custom Delimiter Box.
    Go back to your query select Query --> Results to File. Execute file, Give it a Disk path and a name.</p>
  </blockquote>
  
  <p>but when I converted the .rpt file to .txt [...also in instructions ...], I don't see any pipes.</p>
  
  <ol>
  <li><em>Should</em> I be <strong><em>seeing</em></strong> pipes between the field values?</li>
  <li>If so, is there something missing or incorrect in the instructions?</li>
  </ol>