[thelist] RE: Wordsearch in ASP/Access

Kevin Stevens kjs at ratking.co.uk
Tue Oct 1 14:20:01 CDT 2002

> 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.

Nope, as I said, it's most likely to be done in Access. This will not be a
high traffic site so there is no real fear of Access choking. I do really
want an exact match if possible, I often spend ages when using a search
facility on a site only to discover it is not searching for the exact word I
want. I'm not afraid of working this out for myself, but I don't really know
what I'm looking for, having tried Google and 4 Guys, and I really need to
get on with this. Anyone ???

Kevin Stevens
kjs at ratking.co.uk

More information about the thelist mailing list