Q&A for professional and enthusiast programmers
SELECT TOP 50 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS Link, (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 UPPER(Location) LIKE '%Turke%' OR UPPER(Location) LIKE '%Türki%' ) ORDER BY Reputation DESC;