July 25, 2019 at 4:42 pm
I have the following stored procedure that will run a query doing a search on a table that is indexed for a full text search.
CREATE PROCEDURE [dbo].[usp_SearchResumes]
@SearchFor nvarchar(500)
AS
SET NOCOUNT ON
SELECT
A.UserID,
A.LastName,
A.FirstName,
A.AppDateTimeStart,
J.JobTitle,
F.Abbreviation
FROM
dbo.Applicant_Resume R INNER JOIN
dbo.Application A ON R.UserID = A.UserID INNER JOIN
dbo.Jobs J ON A.JobID = J.JobID INNER JOIN
dbo.ElectronicFolder F ON A.FolderID = F.FolderID
WHERE
CONTAINS(R.FileSource,@SearchFor)
If the user has a phrase that is not surrounded by quotation marks, then it throws an error. The documentation shows that it should work but I get this error
Syntax error near 'force' in the full-text search condition 'air force'.
What do I need to do to correct this?
July 26, 2019 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply