Issue with Search - NEAR - and address format
While playing with multiple address formats try to get the csv importer to map the listing address I came across this issue.
If my uploaded addresses have a comma between the city and state, and the user types in city state with no comma it will not return matches.
If my uploaded addresses do not have a comma between city and state, and the user types in city, state with the comma it will not return matches.
What would cause the -NEAR- function to be so specific that it only accepts the format with or without comma?