Search Algorithm Implememtation

Hi,

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

Thanks,
Sam