I reviewed the SQL queries being sent to the database in SQL Profiler, and I see that when I use the standard match, you replace the single quote with two single quotes, but the exact same query constructed in the advanced match window doesn't have the single quote replaced. I've tried all manner of methods to handle the single quote, but it appears there's nothing I can do to fix the problem.

Is there a patch or update you can release to do the single quote substitution on advanced match criteria?