List of Users in a given location. Not Case Sensitive
Q&A for those involved in the field of teaching Computer Science
-- List of Users in a given location -- Not 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 ( lower(location) like lower('%##location##%') -- For the abbreviation right side match, lead with a space -- Enter dummy if not required or lower(location) like lower('%##AbbreviationRight##') ) -- exclusions and not ( -- Enter dummy if not required lower(location) LIKE lower('%##Exclusion##%') --or lower(location) LIKE lower('%##ExclusionRightSide##') --or lower(location) like lower('dummy') ) order by location asc -- to pick out incorrect results