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 +>
>
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
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 ?