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 +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: [EMAIL PROTECTED]> To: [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'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/msnnkmgl0010000006ukm/direct/01/ _________________________________________________________________ All new Live Search at Live.com http://clk.atdmt.com/UKM/go/msnnkmgl0010000006ukm/direct/01/