Full Text search query

• mjohnson 71479

  SSC Eights!

  Points: 846

  More actions

  July 25, 2019 at 4:42 pm

  #3666129

  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?

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  July 26, 2019 at 5:10 pm

  #3666413

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.