Q&A about the site for scholars and enthusiasts of literature
DECLARE @location AS nvarchar(max) = ##location:string##; SELECT * FROM Users u WHERE lower(u.Location) LIKE lower('%' + @location + '%') ORDER BY 'Reputation' DESC