I have a Crystal Report that prompts for an item number that is used to populate the report. Because the item number looks like 'ITM0000001234', very often the value is entered incorrectly.
How do I configure my selection formula to only to search for the item in a like format.
i.e. where item like "%1234" in Crystal?
I'm using Crystal 9.0