searching with SQL Server 2000

[ELF]

I would like to do a searching function as like as google, of course
example:
user enter "testing company"

the result will like as below:
1. testing happy company
2. testing company
3. abc company
4. happy testing company

that means any record contain either testing or company will display, does
it named full-text searching? and how to done it?

thx~~

[Bob Barrows]

ELF wrote:

> I would like to do a searching function as like as google, of course
> example:
> user enter "testing company"
>
> the result will like as below:
> 1. testing happy company
> 2. testing company
> 3. abc company
> 4. happy testing company
>
> that means any record contain either testing or company will display,
> does it named full-text searching? and how to done it?
>
> thx~~

Start by going to your SQL Server program group in your Windows Start menu
and opening SQL Books Online. Then. in the table of contents, go to SQL
Server Architecture>Relational Database Engine Architecture Overview>
Full-Text Query Architecture and start reading. The articles in this section
will contain links to other relevant articles.

Further questions about this topic should be directed to the
..sqlserver.fulltext newsgroup, and I've cross-posted and set the Follow-ups
for this post to that group.

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"