SQL Full Text Search / Full Text Indexing

[RhythmAddict112]

Hi all,
Long time no post. I have a few questions regarding SQL Full-Text Searching/Indexing in a SQL 2K environment. We've got the business need here to build a search engine on top of a database. I'll need to do the "Normal" search, where I specify the value I want to look for in a certain column from a web front end - no problem there. But, I also have the need to search for keywords across multiple text columns. For example, search for "Accounting" across 5-10 columns. Is SQL Full Text Searching something that can handle this with acceptable performance? I'd like to hear from others that have done this and what tools they've used.

Thanks!

http://geekswithblogs.net/sanjayu/

 

[mrdenny]

Full text search is what you want to use.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[RhythmAddict112]

Rockin'. Thanks!

http://geekswithblogs.net/sanjayu/

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com