>Yes and no. Full-text indexing does provide the functionality that you're looking for but your query is wrong. Full-text indexing requires that you query use CONTAINS, CONTAINSTABLE, FREETEXT, orFREETEXTTABLE.
Ok, so when querying in such circumstances, additional clauses apply in the SQL. For the isolated locations where it applies, this shouldn't represent a problem.
>Also, Full-Text indexes are NOT dynamically maintained. You will have to schedule a job to update them.
No problem there, this is the current approach we are using.