Skip to content
Advertisement

Tag: freetext

Using SQL to Return Entire Paragraph if a word is found

I would like to return all the words surrounding the search term in a varbinary text enabled column. For example, if the word crisis is found, I would like to return the paragraph or at least 10 words on each side of the searched word. I am able to use the free text feature but I’m stumped as to how

Advertisement