| | |
|
|
|
Search word in sentences |
|---|
| message from Him on 15 May 2004 |
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?
|
| Douglas J. Steele replied to Him on 15 May 2004 |
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.
|
|
Archived message: Search word in sentences (Microsoft Access Database)
