December 30, 2003 at 9:38 am
I am new to SQL Server, but have recently installed it and I am evaluating it for some upcoming projects. I have a question concerning the full-text search in that regard. I'm looking for a way to do a comparison of paragraphs. I'm developing an application that tracks a company's capabilities, and also customer needs. The capabilities and needs will be input as free-text into the database. I then need to create a gap analysis feature to report deficiencies in capababilities when compared to customer needs. So...my question is: will SQL Server's full-text search satisfy the need to compare free-text fields? I did see there is a FREETEXT operator to use with SELECT statements, but I don't know how robust this is.
For example, let's say a current capability is "Offers database administration services",
and a customer need is "Maintain SQL Server database". Will the full-text (FREETEXT) search return these as a match? This is a very simple example, but hits on the essentials. Realistically it would be nice to compare phrases that do not contain any words in common, but I'm sure that would have to be accomplished by a third-party app.
Thanks!
Edited by - fillae on 12/30/2003 09:38:47 AM
January 2, 2004 at 8:00 am
This was removed by the editor as SPAM
January 2, 2004 at 10:36 am
Not entirely sure, but I'd say 3rd party app as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 11:48 am
Thanks for the reply. After further research, I think the FREETEXT query will satisfy most of my requirements. Associating the word "storage device" with the word "database" is a more difficult problem, but not a version 1 problem.
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply