List of Most reputed users in a given location - Case Sensitive

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

-- List of Users in a given location
-- Case Sensitive
SELECT
Top ##Top##
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
Reputation,
Location,
--CreationDate,
LastAccessDate,
UpVotes,
DownVotes
FROM
Users
where (
location like '%##Location##%'
--For the abbreviation right side match, lead with a space
-- Enter dummy if not required
or location like '%##AbbreviationRightSide##'
)
-- exclusions
and not
(
-- Enter dummy if not required
location LIKE '%##Exclusion##%'
or location LIKE '%##ExclusionRightSide##'
)
order by location asc -- to pick out incorrect results