Q&A for professional and enthusiast programmers
SELECT TOP 50 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id as [User_ID], (case when DisplayName LIKE '%arbar%zha%' then '[| '+DisplayName+' |]' else DisplayName end ) as DisplayName, Reputation, Location FROM Users WHERE (LOWER(Location) LIKE '%turke%' OR LOWER(Location) LIKE '%türki%' OR LOWER(Location) LIKE '%turki%' ) ORDER BY Reputation DESC;