[thelist] replacing line breaks in sql 2000

[Brian Cummiskey]

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?