SQL: how to embed parameter inside quotes for wildcard %

I would like to know how to modify a SQL statement to embed a parameter inside quotes. I want to use the parameter inside of a statement such as: SELECT * from table WHERE col LIKE '%@parm'

I can get the query to work without the parameter, just not with it?? Is there a CS3 workaround?

Thanks