I've overcome the problem by using a RichText memo box. Thanks for your help in any case.

Neil



> From: neildtompkins@hotmail.com> To: gclark@suppliersystems.com> CC: mysql@lists.mysql.com> Subject: RE: replace chr(10) in field> Date: Wed, 14 May2008 19:18:07 +0000> > I thought this, but when I display the information in a Memo box in my C++ builder application I get little square boxes (binary type chars). And all the information is displayed on the same line.> > Any ideas why ? > > > > > Date: Wed, 14 May 2008 13:08:04 -0500> From: gclark@suppliersystems.com> To: neildtompkins@hotmail.com> 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'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? I tried using the mysql REPLACE() function, but it did not appear to work.> > > > Thanks,> > Neil> > __________________________________________________ _______________> > > > All new Live Search at Live.com> > > > http://clk.atdmt.com/UKM/go/msnnkmgl0010000006ukm/direct/01/> > Chr(10) is a \n.> Chr(13) is a \r.> -- > Gerald L. Clark> Sr. V.P. Development> Supplier Systems Corporation> Unix since 1982> Linux since 1992> __________________________________________________ _______________> > All new Live Search at Live.com> > http://clk.atdmt.com/UKM/go/msnnkmgl...ukm/direct/01/
__________________________________________________ _______________

All new Live Search at Live.com

http://clk.atdmt.com/UKM/go/msnnkmgl...ukm/direct/01/