What character do I use for a "wildcard" and how should I use it?

Wildcards are used with the "Matches Pattern" operator to retrieve data that is like a value, rather than exactly equal to it.

For example, using a percent sign ( % ) in the query filter COA_Fund Matches Pattern '5%' will retrieve all funds (to which you have access) from 500000-599999.

Similarly, if you're trying to match almost the exact syntax, you can use an underscore ( _ ). For example, COA_ORG Matches Pattern '91_2' will retrieve ORG values 9132, 9142 and 9152.