Full-text indexing and 'contains'

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

Transact-SQL (2000)

Full-text indexing and 'contains'

Author

Topic

iminore
Posting Yak Master

141 Posts

Posted - 2009-10-15 : 10:03:48

Suppose I have a table, under full-text indexing, with column data containing values 'law','lawson','byelaw'. I do a select using CONTAINS '"*law*"'. The first two records are returned but not the one with 'byelaw'.
Any ideas?

My word is my code.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources