Appending a string with param value while passing it to cmd

[Former Member]

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

[Former Member]

I solved the problem by dropping the "&" sign now the report returns the exact # of records from the table. Modified where condition:

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

[Former Member]

Thanks for your reply ,It's SQL 2012and crystal report is cr2013!

[abhilash_kumar]

Hi Dev,

Which database are you reporting against?

-Abhilash