Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As * is a wildcard character that matches any string, it gives me the first row, not the first row containing an asterisks.

share|improve this question
Does "[*]" work? – Daniel Beck Jan 18 '12 at 12:34
No, unfortunately not – Muleskinner Jan 18 '12 at 12:36
up vote 0 down vote accepted

Enclosing the asterisk in your search string in square brackets, i.e. "[*]", is in fact the correct answer. This is according to Microsoft documentation. And here's the proof:

enter image description here

Works like a charm! Perhaps what you are missing is the "Any Part of Field" setting?

share|improve this answer
Thanks, but not working, heres the proof: Im using Access 2007 SP2. H – Muleskinner Jan 19 '12 at 11:10
Hey, Muleskinner! YES, it DOES work - when you set the "Match" to "Any Part of Field" like I said specifically in my answer. Setting Match to "Whole Field" as you show in your screen grab will only find a record where there is an asterisk AND NOTHING ELSE in the field. Please accept my answer as correct since the real issue is the "Match" setting which I pointed out. Thanks! – Dave Becker Jan 19 '12 at 14:28
Sorry, in my screenshot I made a mistake with the match settings. But I did try your suggestion and have to say that you are wrong - it might work for you and others, but it does not work for me, see I would really like to accept your answer, but how can I if it does not answer my question? – Muleskinner Jan 19 '12 at 20:53
I hear you that it does not work for you - but that doesn't make me "wrong". You said "it might work for you and others". I'm saying as nicely as I can that it DOES work for me and I'm sure for most/many/all others. Here's the video on YouTube: So the question is not "How do I..." (which I answered correctly!) but "Why doesn't this work for me?" Good luck finding the answer... – Dave Becker Jan 20 '12 at 0:31
thanks for trying to help – Muleskinner Jan 21 '12 at 21:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.