The answer to that is not as clean as it should be. By default dbFront assumes that users want to do a like search so if you don't specifically include a '%' in the search string then it will surround your search text by '%' as follows: '%YourText%'.
You can adjust the search by specifically including a '%'. By including a '%' at the end you would prevent "West" matching to "Midwest".
