List of Users in a given location. Case Sensitive
Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
-- 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, LastAccessDate, UpVotes, DownVotes FROM Users where ( location like '%##Location##%' or location like '%##AbbreviationRightSide##' ) order by Reputation asc -- to pick out incorrect results