Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software
SELECT TOP 50 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS Link, DisplayName, Reputation, Location FROM Users WHERE (LOWER(Location) LIKE '%taiwan%' OR UPPER(Location) LIKE '%Taiwan%' OR Location LIKE '%台灣%' ) ORDER BY Reputation DESC;