How to SELECT WHERE LIKE '%@Param%'

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.

Frankly you should avoid doing this type of query altogether. Ther is no way a query like this can use an index. Why do you need a wildcard for the first character? Is youe data model bad , storing things ina comma delimited string perhaps? Or is this something that woudl be better served with using a full-text index? Wanting to do this is a huge database smell. — HLGEM, Dec 19 '11 at 22:02

score 7 · Accepted Answer · answered Dec 19 '11 at 20:28

7

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

answered Dec 19 '11 at 20:28

hspain

score 1 · Answer 2 · answered Dec 19 '11 at 20:28

1

Here you go.........

LIKE '%' + @PARAM + '%'

answered Dec 19 '11 at 20:28

Valamas

2 Answers2