• Not like that, but you could use a table value constructor and join to that.  I think that would work.  If you post up some table DDL (CREATE TABLE statement) and sample data (INSERT statement(s)), someone may give you a tested query.

    AND ServText LIKE '%' + TVCText + '%'

    John