Check if a value is inside a sql String field with many values

I have a sql field with values like "test had, that , much never";

I want to know wether "had" is in that list if yes return the whole datarow.

There was a sql server function like "I开发者_JAVA百科n" Select value in (fieldname)...

anyone can tell me, thanks :)

p.s. dont want to use the "like" which is slow.

---

If you don't want to use LIKE consider Full Text Indexing and the CONTAINS statement instead.