[sql2008] charindex su varchar(max)

[optime]

select colonne from tabella where '|'+colonna LIKE '%|' + @valore +'|%'

that easy!