I have a phonebook program which essentially takes a search and goes through a data base to find matches and displays the results. I am using full text searching but my problem is that if I search for an exact name, The program will display everything that is close to the search BUT the exact name.
eg: If i search "bob smith" The results will display everything close to bob smith... such as "bob smithe, rob smith, etc..." but will not display "bob smith"
If i search "rob smith", bob smith will be displayed in the result but not "rob smith".
Thanks for the help!