Test: List of Users in a given location - Case Sensitive

-- List of Users in a given location
-- Case Sensitive
select
Id as [User Link],
location,
reputation
from users
where (
location like '%##Location##%'
--For the abbreviation right side match
or location like '%##Abbreviation##'
)
-- exclusions
and not
(
location LIKE '%##Exclusion##%'
)
order by location asc -- to pick out incorrect results