[thelist] replacing line breaks in sql 2000

Brian Cummiskey brian at hondaswap.com
Thu Dec 20 16:34:10 CST 2007

Hi guys,

I have a problem with a feed i'm working on.   The flat-file export is 
giving me some headaches due to linebreaks.

viewing the file in notepad, i can see the hard break char [] square.

This is the update i'm using before export:

declare @NewLine char(2)
set @NewLine=char(13)+char(10)

update @temp
   	 set OfferDescription = Replace(OfferDescription , @NewLine,'')
	WHERE OfferDescription like '%' + at NewLine +'%'

am i missing something?

should i split out char(13) and char(10) to separate entities?

More information about the thelist mailing list