This worked, thanks!

Now for my side question:

What if my field only had a Percent Sign in it?

='[%]' and =[%]

do not work.

Thanks to all for the suggestions.

I got my query to work!!

I'm having the same problem. Was there a final solution found for this?