View Full Version : Searching through a string

01-17-2005, 10:37 PM
It would seem that I need a powerfull string manipulation Function

If I get the query string (Search string) from a 'Form' could be "How do I remove a desktop icon" then get the words to search against, from the 'Keywords' table in DB.
So Search the 'Keywords' for matches equal to the 'Search string"
maybe even drop certain words like 'do','how' and other words of little descriptive value.
I suspect a lot of search engines do this sort of thing.
I need some examples

01-18-2005, 01:21 AM
Perhaps this may hopefully give you some ideas:

Classic ASP Design Tips - Search For Keywords on Multiple Fields

The above searches on each single word. And yes you could combine that with removing things like the word TO in a search string:

strSearchString = Replace(strSearchString, " to ", " ") ...