Q&A for committed Christians, experts in Christianity and those interested in learning more
-- List of users in a given location "somewhere" -- 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('%somewhere%') ) -- exclusions and not ( -- Enter dummy if not required lower(location) LIKE lower('%##Exclusion##%') or lower(location) = lower('somewhere') or lower(location) LIKE lower('%Asia%') or lower(location) LIKE lower('%America%') or lower(location) LIKE lower('%botswana%') or lower(location) LIKE lower('%California%') or lower(location) LIKE lower('%computer%') or lower(location) LIKE lower('%earth%') or lower(location) LIKE lower('%europe%') or lower(location) LIKE lower('%Germany%') or lower(location) LIKE lower('%India%') or lower(location) LIKE lower('%Internet%') or lower(location) LIKE lower('%italy%') or lower(location) LIKE lower('%london%') or lower(location) LIKE lower('%Paris%') or lower(location) LIKE lower('%planet%') or lower(location) LIKE lower('%somewhere%over the rainbow%') or lower(location) LIKE lower('%spain%') or lower(location) LIKE lower('%Universe%') or lower(location) LIKE lower('% UK%') or lower(location) LIKE lower('%USA%') or lower(location) LIKE lower('%united states%') or lower(location) LIKE lower('%ocean%') or lower(location) LIKE lower('%dummy%') or lower(location) LIKE lower('%dummy%') ) order by location asc -- to pick out incorrect results