在SQL中查询分隔Varchar字段的有效方法

I have an SQL Server 2005 table that has a varchar(250) field which contains keywords that I will use for searching purposes. I can't change the design. The data looks like this...I have an SQL Server 2005 table that has a varc