CONTAINS Prefix Term - 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 2005 Forums

Transact-SQL (2005)

CONTAINS Prefix Term

Author

Topic

Dennis Falls
Starting Member

41 Posts

Posted - 2010-10-19 : 22:07:35

I have a table, tblvisit, with a full text index on columns complaint and notes. When I run:

select complaint,notes
from tblvisit
where CONTAINS(complaint,'"r m s f*"')

it returns a dataset with terms such as Rocky Mountain Spotted Fever. However, if I run

select complaint,notes
from tblvisit
where CONTAINS(*,'"r m s f*"')

or

select complaint,notes
from tblvisit
where CONTAINS(notes,'"r m s f*"')

the result is 0 records returned. I would at least expect results when I run CONTAINS(*,'"r m s f*"').

Any ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources