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.

LIKE concat('%',???,'%')

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.

See Also