· · (0) · ·

when you output sql text manually creating CSV file output format, you may need to adjust for quote delimited data if that data contains your delimeter or line feeds.

this code snippet is for 'comma' delimited output.

SELECT
  CASE PATINDEX('%[,"\r\n]%', [MyColumnData])
  WHEN 0 THEN [MyColumnData] -- not found
  WHEN NULL THEN [MyColumnData] -- unknown
  ELSE '"' + REPLACE([MyColumnData],'"','""') + '"' -- encode data
END
AS [MyEncodedOutput]