List of Users in a given location. Case Sensitive
Q&A for professional and enthusiast programmers
-- List of Users in a given location -- Case Sensitive select Id as [User Link], location, reputation from users where lower (location) like '%##location##%' --For the abbreviation right side match --where location like '%##location##' -- exclusions and not ( lower (Location) LIKE '%##dummy##%' or (Location) LIKE '%BCN%' -- Barcelona ) order by location asc -- to pick out incorrect results