SEARCH TIP: How to use % to do a “contains” wildcard search

posted Mar 28, 2014, 10:20 AM by Peyri Herrera
You can use the % sign to do a “contains” wildcard search by using it in conjunction with the desired value, even if the search operator is set to “begins with.”

For example, search by “begins with %20” to return results that contain a 20. In this example, we searched for any PO ID that contains a 20.
%20

Search by “begins with %mag” for results that contain mag. In this example, we searched for any Supplier Name that contains mag, like the words Imagine, Imaging, Magazine, and so on.
%mag