compare

hi i doing a project like "IMesh", whatever ,i will take a sentence
from the user and want to retrieve all row from the table has similar
words
for example the user enter "programming with c#" so i retrieve all
fields that contain "programming" or "c#"
some thing like what a search engine do
thanxamir samir (amir_s_anwar@.yahoo.com) writes:
> hi i doing a project like "IMesh", whatever ,i will take a sentence
> from the user and want to retrieve all row from the table has similar
> words
> for example the user enter "programming with c#" so i retrieve all
> fields that contain "programming" or "c#"
> some thing like what a search engine do

You probably want to look at full-text indexing.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp