SelectInField Trigger with Search String Include wildcards and spaces

[#1]

I am trying to search for " PUSH " and " PER " and I want to include the space at the front and back to make sure I only get the single word, but when I add the wildcard * to the mix so that I can search within a text string I can't get the filter to work.  Can someone help with the correct syntax.  I have tried the 3 following options which seem to be the most logical, but none work.  I have also tried some variations with single quotes with no luck.

(* PER *|* PUSH *)

("* PER *"|"* PUSH *")

(*" PER "*|*" PUSH "*)

I am also applying the UPPER() function to the Field to ignore the case sensitivity, could that be what is causing the problem?

Thanks!

[sunny_talwar · Accepted solution]

The middle one seems to work for me:

("* PER *"|"* PUSH *")

[#3]

Thanks!  Apparently it was the button action that wasn't triggering, I moved the action to a text box and it worked

[sunny_talwar]

Awesome

I am glad you were finally able to figure it out.

Best,

Sunny