[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
a
word like : ability - the like operator will match ability, disability,
inability
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
capabilities.

HTH

ashok

------
Ashok Hariharan
http://www.unganisha.org
------











More information about the thelist mailing list