[snip] Try: replace(replace(dealerLong, '\n', ''), '\r', '') [/snip]
Didn't work, perhaps because they are hidden. I ended up taking the long road; update table set foo = replace(HEX(foo), '0D', ''); update table set foo = UNHEX(foo); HEX allowed me to see the carriage return (0D) and then use replace syntax to fix. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
