Correct syntax for this Contains statement

• isaac_654135

  Default port

  Points: 1414

  More actions

  October 5, 2023 at 5:15 pm

  #4302184

  I want to search a table alias doc, column name Result, where doc.Result is full text indexed, using Contains, and I want to find where there is the term BSA and a % sign (percent sign, literally) within 5 words of each other.

  Do I have to escape the % sign like [%] ?  that seems to come back wrong syntax

  This returns zero results but that may be accurate, not sure.  the [%] returns syntax error

  where contains(doc.Result,'NEAR((BSA, %), 5)')

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 6, 2023 at 6:10 pm

  #4302916

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

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