 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / February 2006CONTAINS on sql2005
I've just discovered that the CONTAINS clause on sql2005 can search multiple columns - great! Is there a way to return which column the search word(s) were found in? Dunc Regretably not.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > I've just discovered that the CONTAINS clause on sql2005 can search > multiple columns - great! > > Is there a way to return which column the search word(s) were found in? > > Dunc On what edition did it work - just enterprise edition or even on standard (and if so what is required to get it going?) Jan > I've just discovered that the CONTAINS clause on sql2005 can search > multiple columns - great! > > Is there a way to return which column the search word(s) were found in? > > Dunc |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.