Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS Position ,DisplayName ,Reputation ,WebsiteUrl ,AboutMe ,'http://stackoverflow.com/users/' + CONVERT(VARCHAR(10), Id) AS ProfileUrl FROM Users(NOLOCK) WHERE UPPER(Location) like N'%IRAN%' OR Location like N'%, IR' OR Location like N'%,IR' OR UPPER(Location) like N'%İRAN%' OR Location like N'%IR%' OR UPPER(Location) like N'%MASHHAD%' OR UPPER(Location) like N'%ISFAHAN%' OR Location like N'%KARAJ%' OR UPPER(Location) like N'%TABRIZ%' ORDER BY Reputation DESC