title: How to replace CHAR(13) in DB varchar(6000)?
body: <p>Using ColdFusion and Microsoft SQL we are exporting data to an Excel Spreadsheet using the cfx_excel plugin. The data contains a varchar(6000) which has CHAR(13)/line-breaks inputted in each entry.</p>
  
  <p>The line-breaks are appearing as square brackets every time the report is generated in Excel format.</p>
  
  <p>How would I go about removing the CHAR(13) within a SQL query?</p>
  
  <p>Thank you.</p>