Search word in sentences

  • Thread starter Thread starter Him
  • Start date Start date
H

Him

In my database, there is a column, which the data in this column is a sentence.

How can I find out the sentences which contain a particular word by creating a Query?
 
Assuming the field in your table is named Sentence, and you're looking for
word,

WHERE Sentence LIKE '*word*'

You may want to use

WHERE Sentence LIKE '* word *'

so that you don't find cases where your word is contained within another
word (can and scandal, for instance), but that lead to missing words when
they're are the end of a sentence, so that there's a punctuation symbol
after.
 
Back
Top