title: Pipe delimited output
body: <p>I have the below code that I need the format in pipe delimited format. I tried adding +'|' but seems I am not putting that correctly so it keeps on throwing errors. It can't be a stored procedure because of the rights. Also, I cannot change the result output permanently so can't use the tools-options menu. Could someone please add the pipe correctly for me in the below select statement. Thanks a ton. I am so confused.</p>
  
  <pre><code>SELECT  DISTINCT
  Name,
  CAST(DOB AS DATE) AS DateOfBirth,
  Address1 AS AddressStreet1,
  Address2 AS AddressStreet2,
  City AS AddressCity,
  State AS AddressState,
  Postal AS AddressZip,
  Sex AS Gender,
  CAST(ActivityDateTime AS DATE) AS ActivityDate,
  CASE
      WHEN ID IN ('R','A')
      THEN 'Y'
  ELSE 'N'
  END AS Allow
  </code></pre>