Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .