Microsoft Search Service

Microsoft Search Service maintains and performs full-text searching. It is used to index, catalog and query information. It runs as a separate background service that enables SQL Server 2000 and other programs to process full text data request.

A full-text search using Microsoft Search service enables you to query character-based data in table. This means that most often a full-text query searches for particular words or phrases in character based columns.

Microsoft Search service perform a linguistic search of character data in table.

Ex:

Select FieldName From TableName Where CONTAINS(FieldName, 'Text to be Searched')

Select FieldName From TableName Where FREETEXT(FieldName, '"Some portion of text to be Searched"')