Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Location, Reputation FROM Users u WHERE LOWER(u.Location) LIKE LOWER('%##Location##%') ORDER BY Reputation DESC;