Using Substring with ContainsTable

• rash3554

  SSCommitted

  Points: 1984

  More actions

  December 19, 2016 at 3:42 am

  #316023

  Hi there,

  I want to do FulltextSearch on only 500 characters of columns in a table to find employees and companies that use Natural Language processing (NLP)

  Employee table has Employee ID, COmpanyNames, Present jobdescription and Brief description of company and ManagerID(if exists).

  I want to do this

  CONTAINSTABLE(dbo.Employee, (SUBSTRING(JobDescription,1,500),CompanyInfo),'ISABOUT("NLP" weight(.1))',LANGUAGE N'English',1000000) as fti

  But I get an error saying that "Incorrect syntax near '('."

  How can I do this

  Thanks

  MR

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  December 19, 2016 at 6:56 am

  #1918659

  rash3554 (12/19/2016)

  ---

  Hi there,

  I want to do FulltextSearch on only 500 characters of columns in a table to find employees and companies that use Natural Language processing (NLP)

  Employee table has Employee ID, COmpanyNames, Present jobdescription and Brief description of company and ManagerID(if exists).

  I want to do this

  [font="Courier New"]

  CONTAINSTABLE(dbo.Employee,(SUBSTRING(JobDescription,1,500),CompanyInfo),'ISABOUT("NLP" weight(.1))',LANGUAGE N'English',1000000) as fti

  [/font]

  But I get an error saying that "Incorrect syntax near '('."

  How can I do this

  Thanks

  MR

  Take a look at the text I highlighted. I suspect that it's complaining about the fact that you have a substring function followed by a comma and what appears to be another field, all in parentheses. As I'm not familiar with FULLTEXT functions, I'm guessing, but most functions of any kind separate ALL their parameters with just commas, and it appears that the extra parentheses MIGHT be the trouble.

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)