Q&A for professional and enthusiast programmers
SELECT Distinct u.Id AS [User Link], CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link], u.DisplayName, u.Location FROM Users u WHERE Upper(u.Location) LIKE Upper('%##Location##%') ;