2000 DTS remove carriage returns during export to file

• stamic

  SSC Eights!

  Points: 867

  More actions

  November 11, 2009 at 9:08 am

  #136903

  Hello, I would like to know the best strategy for removing carriage returns from a field during an export to file. Any ideas? Thanks

• Carol Adams

  SSCrazy

  Points: 2320

  More actions

  November 11, 2009 at 12:40 pm

  #1077996

  replace(convert(varchar(8000),sv_inq_txt.inquiry_txt),char(13)+char(10),'

  ')

  In the above, I replaced CR/LF with

  ....change '

  ' to ''