On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n',''); BTW \n = null \0 seems to be something else Turns out my rotten character (they all seem to display as a hollow box) was a \r thanx zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]