Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

SQL Server Full Text Search - AND searches across multiple columns

Does anyone know how to accomplish this?  The search below only returns results when a specific column matches both words.  I want it to match if all words are matched, but in any full-text indexed column.  Anyone know if this is do-able?

DECLARE @keywords nvarchar(100);
SET @keywords = '"William*" AND "Travis*"';

SELECT RANK AS RES_RANK, * FROM VW_REQUESTOR_AGENCY_SEARCH,
CONTAINSTABLE (VW_REQUESTOR_AGENCY_SEARCH, *,  @keywords) AS TBL_SCH
WHERE [KEY] = VW_REQUESTOR_AGENCY_SEARCH.REQUESTOR_ID

Open in new window

0
msdcdev
Asked:
msdcdev
1 Solution
 
msdcdevAuthor Commented:
According to several articles, the answer is to add a computed column on the view that concatenates all of the fields that you want to search.  Then, change your full text index to only include the computed column.  Then the query shown above works with no changes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now