Freetext Partial Matches - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Freetext Partial Matches

Author

Topic

Pretsel
Starting Member

1 Post

Posted - 2002-11-08 : 02:28:09

Im attempting to build a very simple search engine, using full text queries. In particular Im using the freetext predicate. One of the things I noticed was freetext doesn't return partial matches, IE

select *
from words
where freetext(*,'col')

wont return all the records which 'partially' match this search string. (column, colspan etc)

Is there a way to turn on partial matching or should I look into some other method?

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-11-08 : 04:15:44

Try CONTAINS instead of FREETEXT. Read more about it in BOL...

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-11-08 : 15:01:16

As previously suggested, use CONTAINS. This allows you to use * as a prefix term (as well as giving you a more precise result)

 
select * 
from words 
where contains(*,' "col*" ')

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources