0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 10

created sep 30 14 anonymous