Hi, I've successfully used the following update-replace statement to replace strings in mysql data
update tbl_county_lookup set countyname=replace(countyname,'&','and') ; However I've had problems trying to replace a null character 0x00h , I'd be interested to know the syntax to filter null characters. Secondly I'd be interested in a general filter for non-ascii. cheers 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]