How to SELECT WHERE LIKE '%@Param%' [duplicate]

Question

Possible Duplicate:
How to Use 'Like' with a parameter

How do you do this?

 SELECT * FROM TABLE WHERE COL LIKE % @PARAM %

I would like to avoid passing %value% in a statement.

Answer 1

SELECT * FROM TABLE WHERE COL LIKE '%' + @PARAM + '%'