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 froma 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/msnnkmgl...ukm/direct/01/