I am having problems when trying to search a field that contains spaces between words. For example, when searching for "St Albans", there is a space between the words "St" and "Albans". This results in no matching records even though there are multiple entries for "St Albans"

You can test this by going to the URL I provided. 

1. Enter "3000" in the House Number search box. 
2. Enter "St Albans" with a space after the letter "t" in the Street search box. 
3. Press "Search"
4. You will not get any results.
5. Now try the same search but only enter "St" with no space after the letter "t" in the Street search box. This search will return results. 

How can I resolve this issue? This becomes a big problem since I have over 300,000 property addresses (will be adding many more soon). I need people to be able to enter a street that includes spaces when doing a search. As I'm sure you are aware, most street addresses are comprised of multiple words each of which has a space between them.

Hi Aleksandar,

Thanks for your help. It looks like I only had partial data in the "Street" column of the SQL database. I have updated and corrected the database, however, I am still having some issues with the search. I have confirmed that the "Street" column is NOT set to exact search.

For example, lets say the owner of the property at "3000 St Albans Mill Rd 101" is trying to search the database for their property. They would enter "3000" in the search field "House Number", but might enter any of the following in the "Street" field.

• "St. Albans" - notice the "." after "St"
• "Saint Albans"
• "St Albans Mill Road"
• "St Albans Mill Rd"
• "St Albans Mill Rd #101"
• "St Albans Mill Rd 101"
• etc.

Is there a way to allow more flexibility in the search results so that when someone enter these near matches they don't get the "no matching records found".