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

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-03-18 : 07:33:27
Hi,
Is there a way to include the noise words when searching using contains?
i.e. select field1 from table1 where contains(field1, '"out of this world"')
Thanks

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-18 : 07:56:17
the noise words are managed via a file containing the list of noise words. edit that file

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-03-18 : 08:44:43
quote:
Originally posted by heavymind

the noise words are managed via a file containing the list of noise words. edit that file

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com


Solved.
Thanks
Go to Top of Page

Nageswar9
Aged Yak Warrior

600 Posts

Posted - 2009-03-18 : 08:48:14
Hi,

How? can U Please Explain Briefly?

Thanks..
Go to Top of Page
   

- Advertisement -