Crystal: Using LIKE in SQL command

[former_member548403]

I'm modifying a report which lists all the positions available in the database. I am trying to use LIKE in the SQL command so that when a user selects a keyword from the parameter, the report will list all the positions related to the keyword, for example, if a user selects "Captain" from the parameter list, which is already set up, the report will show all the positions that include the captain and captain-like.

I have tried using followings in SQL command:

and category LIKE '{?Position}*'

Or

and category LIKE '{?Position}' + '*'

And they do not work. How do I use LIKE in SQL command in Crystal?

[former_member548403]

Figured it out, sort of. This works.

And category like {?Position} + '%'

But does anyone know how to incorporate this into Allow multiple values?