I suggest you use bind variables to solve this problem. If that doesn’t work, you can always use dynamic SQL. Of course, bind variables are faster.
Here is a really informative link. Be sure to check out the follow-up section to the May 21, 2003 entry, as he uses like in the Where clause:
Hope this helps,