This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

END USER TIPS & TRICKS - Wildcard for a single character?

Marcel N - Friday, February 10, 2012 4:14 AM:

Hi everyone,

is there a wildcard that only represents a single character when performing a “simple search”? I'm asking, because those wildcards ‘*’ and ‘%’ represent a variety of characters.

Regards
Marcel



tstickel - Friday, February 10, 2012 9:38 AM:

Marcel

Try the "_" character.  See http://msdn.microsoft.com/en-us/library/ms174424.aspx



tstickel - Friday, February 10, 2012 9:50 AM:

Marcel,

 

Sorry, I tried the "_" and it does not work in the simple search.  You could use the [character list] technique instead.

 

For example [0-Z], should match an single alphabetic/numeric character.

So  [0-Z][0-Z]omp% will search for any first two alpha/numeric characters, followed by "omp", followed by any string.

But a restriction in this technique is that you have to include a % or * wildcard somewhere in the search or it will not work.



Marcel N - Monday, February 13, 2012 7:23 AM:

Thank you, Terry, that should work for the beginning