Jun 20th, 2012, 03:22 AM
Search Algorithm Implememtation
Want to search particular string in whole database in MS Access using VB6
Search Algorithm would be as below.
Input String : "Medicare Members of Connecticut"
Step 1 : Pharse the entire search string and remove the unwanted words ( In this case 'of' )
i.e Medicare Members Connecticut
Step 2 : Search using the LIKE Keyword ‘%Medicare Connecticut%’
Swap the text and % Connecticut Medicare %’
If we didn’t receive a match then
Break the Input Text
As Connecticut & Medicare
Step 3 : Search using the LIKE Keyword ‘%Medicare %’
Also on % Connecticut %’
And display the entire search results