Use multiple words in FullText Search input string

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 2008 Forums

Transact-SQL (2008)

Use multiple words in FullText Search input string

Author

Topic

darenkov
Yak Posting Veteran

90 Posts

Posted - 2010-08-09 : 01:13:13

I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a @Keyword parameter. It works fine with one word but falls over when I try pass in more than one word. I'm not sure why.


SELECT	S.[SeriesID], 
		S.[Name] as 'SeriesName',
		P.[PackageID],
		P.[Name]		
FROM	[Series] S
INNER JOIN [PackageSeries] PS
ON		S.[SeriesID] = PS.[PackageID]
INNER JOIN [Package] P
ON		PS.[PackageID] = P.[PackageID]
WHERE CONTAINS ((S.[Name],S.[Description], S.[Keywords]),@Keywords)
AND		(S.[IsActive] = 1) AND (P.[IsActive] = 1) ORDER BY [Name] ASC

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources