[thelist] RE: Wordsearch in ASP/Access

listman at hazard0us.org listman at hazard0us.org
Tue Oct 1 01:59:00 CDT 2002

>If everything is going into a database, then you can just run a wildcard
>("%") query:

You could use what david has said about using the 'like "%xyz%" ' operator
though this method will not match word boundaries for instance if you have
word like : ability - the like operator will match ability, disability,
etc... not really the most intuitive matching...

if you have sql server use that it comes with fulltext indexing where you
can match
word boundaries and avoid the above problem.
You can even try using mysql win32 , this again comes with fulltext index



Ashok Hariharan

More information about the thelist mailing list