[thelist] RE: Wordsearch in ASP/Access

[rudy]

> I have considered adding a space before and after the word,
> but this [an exact word match] won't work if the word is at the
> beginning or end of a sentence.

or comma, or period, or question mark, or quotes, or parentheses...

> Is this really possible using Access?

not intelligently

access and sql/server, and almost all databases, support the LIKE operator,
which utilizes simple character string comparison

to my way of thinking, this is adequate for most purposes

see
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_ci
d474892_tax285649,00.html

sorry for the long url

rudy