Try

... WHERE mycolumn LIKE '%' + CHAR(254) + '%' + CHAR(254)+ '%'

>
>I am trying to search through a table of SQL Server where a column has two values of char(254). It does not matter where, the field is a type Text. How would you do it in WHERE?
>
>TIA
>
>UPDATE. Wanted to add the the Text column is not full-text indexed. So Contains() does not work.