Wildcard in where
I have a drop down box that I use as the selection for the where clause in a query, works fine. Now I want to add a wildcard character to get all records. If I use a % character I get a 406 not acceptable error message. I've tried using all manner of quotes around it but get the same. Any ideas?
Thanks