>Hi,
>
>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.

how about

where LEN(columnname) - LEN(REPLACE(columnname,char(254),'')) = 2