List of Users in a given location. Not Case Sensitive
Q&A about the site for music historians, critics, and fans
-- List of Users in a given location -- Not Case Sensitive select Id as [User Link], location, reputation from users where (lower(location) like lower('%##location##%') --For the abbreviation right side match -- lead with a space or lower(location) like lower('%##AbbreviationRight##') ) -- exclusions and not ( lower(location) LIKE lower('%##Exclusion##%') ) order by location asc -- to pick out incorrect results