replace chr(10) in field

[Neil Tompkins <neildtompkins@xxxxxxxxxxx>]

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/