April 8, 2015 at 12:07 am
Hi everyone,
I am searching for the key word 'Platform Customer Support' using full text search.
My code is as below
Set @KeywordSearch = 'Platform Customer Support'
Select AA, BB, CC, DD from SM9..TableName A Right Outer Join SM9_Experiment..TableName C
On A.IncdTouchedGSF like '%' + C.SM9GroupName + '%'
Where
(
Contains(A.[Description], @KeyWordSearch)
And A.OpenTime Between @StartDate and @EndDate
And C.Classification = @GroupNameClassification
)
The code is throwing
Msg 7630, Level 15, State 3, Line 46
Syntax error near 'Customer' in the full-text search condition 'Platform Customer Support.
Can some one help me with this
April 8, 2015 at 7:02 am
I cant see a declaration for the variable using either the declare \ set method or the declare and assign method. This is most likely where your syntax error is coming from. See this for reference:
MCITP SQL 2005, MCSA SQL 2012
April 8, 2015 at 4:26 pm
You need to tell SQL how to match the multiple values. A couple of quick examples:
Set @KeywordSearch = 'Platform AND Customer AND Support'
Set @KeywordSearch = 'Platform NEAR Customer NEAR Support'
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply