How do I make my report accept user prompts with built-in wild cards?
Q: How do I make my report accept user prompts with built-in wild cards?
A: You need to put the following code in the Criteria box of the Report Builder.
Putting this in the criteria box will allow the user to enter isc in the report prompt, and get results like discount or miscellaneous without having to type %isc% as you normally would with the LIKE ??? syntax.