I use below script to export data, (and save to csv through an exporter program,
the Reference field has commas in it,
when I export , the fields with commas become separated, , I need to keep the field together.
Example Reference : 100sd675,PMExvtyr
CONVERT(varchar,InvoiceNumber) AS [InvoiceNumber],
CONVERT(Varchar,Reference) as [Reference]