Find users who's location field contains the specified parameter
Q&A for professional and enthusiast programmers
-- Users Location LIKE '%XXX%' -- Find users who's location field contains the specified parameter SELECT us.DisplayName, us.Id as [User Link], us.Reputation, us.WebsiteUrl, us.Age, us.LastAccessDate, us.Location FROM Users us WHERE Location LIKE '%##Location##%' ORDER BY us.Reputation DESC