Parameters and wildcards

[sqw]

Please can someone help I have a report and want to include a parameter field. I want to be able to type in the name of a customer like "Acme*" and for the parameter to get the result "Acme Ltd Company" or whatever the other part of the company name is.

Thanks

 

[lbass]

Create a string parameter {?Name} and then use a record selection formula like this:

{table.name} like {?Name}+"*"

The user would only need to type in "Acme" in this case (no asterisk). If you want to allow other words prior to the word entered into the parm, change it to:

{table.name} like "*"+{?Name}+"*"

-LB