in reply to Quoting Strings For SQL LIKE queries

btw..doing your manual search/replace 
$str =~ s/'/''/g;

[download]
...will never produce an odd number of single quotes, no matter what the string. think about it :)
the hardest line to type correctly is: stty erase ^H

In Section Seekers of Perl Wisdom