Select in Field & searching a phrase

[#1]

Hi all -

I have a button with an action to Select in Field.  I cannot figure out how to define my search substring to be a specific combination of two words.  I would like to select any values within my specified field that contain the phrase "accounting department" - in that order, and only in with both words (not 'accounting', 'department', or 'department accounting').  What am I doing wrong here?  Thanks!

[tiagopost · Accepted solution]

did you try this  *accounting department* ?

[#3]

Tiago - this worked beautifully.  Thank you very much!  Can you tell my why the second * makes the difference?  I tried *accounting department before (without the second *) and it wasn't working correctly.

[tiagopost]

the first "*" mean anything before

and the seconde "*" mean anything after the key word

if you try just with first *
you would get "one acc depart" in my example, but not the "acc depart test".