Wildcards in Parameters With Multiple Values

[VirtualRichard]

If I have a Parameter {?Test} that accepts multiple strings, I can use:

{TABLE.FIELD} in {?ReportParameter}

To get this SQL:

WHERE ("TABLE"."FIELD"='Selected String 1' OR "TABLE"."FIELD"='Selected String 2')

(Assuming I supplied two choices)

BUT, I need the SQL to look like this:

LIKE '%Selected String 1%' etc...

For the life of me, in the formula editor, I cannot work out the correct terminology to use. I tried:

{TABLE.FIELD} like {?ReportParameter} (doesn't pick up all multiple values - need to use in?)

{TABLE.FIELD} in "?{?ReportParameter}?"

{TABLE.FIELD} in "*{?ReportParameter}*"

(I tried several more desperate approaches, e.g. using ' instead of ").

But to no avail. I'm tearing my hair out here. Can anyone help?

Thanks,

R.

[anhel]

Hello,
Let me see do I understand you correctly:
Let's assume that you have 10 names in one of the fields. You are trying to make a report that includes only the names that contain certain letter or phrase? Is this correct?