RE: replace chr(10) in field

2008-05-15 Thread Neil Tompkins
I've overcome the problem by using a RichText memo box. Thanks for your help in any case. Neil > From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: mysql@lists.mysql.com> > Subject: RE: replace chr(10) in field> Date: Wed, 14 May 2008 19:18:07 +> >

RE: replace chr(10) in field

2008-05-14 Thread Neil Tompkins
o: [EMAIL > PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: replace chr(10) in field> > > Neil Tompkins wrote:> > Hi,> > > > I've got some data in our fields which > contain a carriage return 'chr(10)', as saved using a ASP page. I

replace chr(10) in field

2008-05-14 Thread Neil Tompkins
Hi, I've got some data in our fields which contain a carriage return 'chr(10)', as saved using a ASP page. I'm now trying to extract the information from a different system, however the saved chr(10) are showing as binary values. What would be the best way for my to replace chr(10) to a \n ?