I wanted something a little more user friendly than the advanced search syntax.  Since it's the user doing this and they are not experienced with programming syntax and operators.

Thanks for double checking my results Chris.

Hi Chase,

There is an intermediate-difficulty option that allows you flexibility in your search term without going to the full search syntax: wildcards.

In particular, the bracket wildcards are useful when you are searching via a ID that has a few similar potential values. Bracket wildcards can only replace one character at a time, but they allow for much more targeted searches than a * wildcard. They can be used with a list of potential characters [1257] or a range [1-4].

Examples

• 1961[45] will return entries with a value of either 19614 or 19615
• 1961[4-7] will return entries with a value where the last digit can be 4, 5, 6 or 7 (19614, 19615, 19616, or 19617)
• 1961[478] will return entries with either 19614, 19617, or 19618
• 196[1-4][0-9] will entries with any values in the range from 19610 to 19649

While * is a simpler wildcard, 1961* would return much more varied results: 1961, 19612, 19612222222222, 196193030303939303039303, 1961asdf, etc. It may work for cases such as your where it is an ID field and thus more likely to have, say, a maximum length for the ID.

I'll pass along your feedback, but hopefully this provides a more accessible option for you now.