>>>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.
>>
>>Not sure if I understand the question, maybe something like this?
>>
>>where myColumn like '%FirstString%' and myColumn like '%SecondString%'
>
>Thank you.
Sorry, I read the message before my coffee, after reading Sergey's answer now I understand your question...
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges