Q&A about the site for administrators, end users, developers and designers for Craft CMS
declare @country varchar(max) = '##Country##'; SELECT ID AS UserID, * FROM Users WHERE (Location LIKE @country) ORDER BY Reputation DESC