Using a Parameter in a LIKE Statement

[RSAAdmin]

Is there any way to use a parameter within a LIKE statement. For example: WHERE Message LIKE '%$(parameter)%' When I try this, I receive an error message because the $(parameter) is expanded to '$(parameter)', and the single quotes screws up the syntax. So, for example, if the parameter equals test, you end up getting: WHERE Message LIKE '%'test'%' which throws a syntax error. Thanks, Brian

[RSAAdmin]

Yes, you can do this.

The trick is to type the wildcards in the prompt field when you actually run the report. In the Where Clause for your query, you would simply have:    Message LIKE ${test}

When you run the report, you would enter %search string% in the input field.

The single quotes are assumed to exist, so you don't need to enter them in the Where Clause as part of the report template.

[RSAAdmin]

That works - Thanks for the response!