Skip to Content
Oct 05, 2017 at 03:59 AM

Appending a string with param value while passing it to cmd


I need to achieve the following query for My cmd.

Select a.Name

From table-A a

Where a.msg like '%{?param}&"~"%'

Crystal report processes the query without syntax error but does not return any records.

The table has records in the msg column like g130~Mfger~

I am getting my user to input g130 through the prompt.

Could some one help me with the syntax pleas