Q&A about the site for science fiction and fantasy enthusiasts
-- List of users in Ukraine 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 '%ukraine%' -- http://sustainablesources.com/resources/country-abbreviations/ OR Location LIKE '%UA' OR lower(Location) LIKE 'dummy' ) -- exclusions and not( lower(Location) LIKE '%dummy%' ) and LEN(Location) > 1 --and Reputation > 1 --Temporarily sort by location to more easily pick out false positive entries ORDER BY Location ASC;