Hi Ya. I seem to have solved my problem if I clean out any punctuation from my search string (see below (ColdFusion script))
<cfset form.searchtext=replace(form.searchtext,'[[:punct:]]','','all') > When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes The LIKE appears to ignore the quotes (which is what I want) BUT IS THAT A FEATURE OF LIKE??? zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" 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]