doing a "full text" search with MS SQL Server

[Chip Matthes]

Has anybody used an inverted index to search data kept in SQL Server?
I need to be able to do a full-text search of some varchar and
text columns. With varchar, I can use "select * from xxx where
yyy is like '%zzz%'" but that is VERY slow since it can't use
an index and must do an entire table scan. I'd like to use
an inverted index and wondered if there was a Microsoft or
third-party product that would index and retrieve this data.

--Chip