Simple search engine (newbie)

I don't recall hearing about any particular class for searching in sql server. There is a com interface called iFilter, but normally people simply utilise t-sql to do searches. If it's a table/column level search you can simply use operators such as like, =,<> etc. eg. select * from mytable where mycolumn like '%somevalue%' (note: % is the wildcard character)

If you're looking to perform a deeper search, then look at using fulltext search. It allows operators such as contains, freetext etc., and allows you to query at a catalog level (a catalog can be a number of objects). You just use the sql via the sqlclient namespace as you would a normal query.

Cathal