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]

Reply via email to