Simple configurable query to resolve users to a geography
Q&A for professional and enthusiast programmers
select Id as [User Link], Location, DisplayName, CreationDate, Reputation from Users where lower(Location ) like Lower('%' + ##Location:string## + '%')