Q&A for professional and enthusiast programmers
-- Created by aminography [https://stackoverflow.com/users/1631967/aminography] SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY Users.Reputation DESC) AS [#], Users.Id AS [User Link], Users.Reputation, Users.Location, Users.UpVotes, Users.DownVotes, Users.CreationDate FROM Users WHERE LOWER(Location) LIKE LOWER('%Iran') OR LOWER(Location) LIKE '%Tehran' ORDER BY Reputation DESC;