Q&A about the site for linguists, teachers and students of the Ukrainian language
-- Find users by location -- Shows all the users for the supplied location parameter, sorted by reputation. The parameter is a wild card. SELECT TOP(100) u.Id, u.DisplayName, u.Reputation, u.WebsiteUrl, u.Age, u.LastAccessDate, u.Location FROM Users u WHERE (u.Location LIKE ##Location:string##) or (u.Location like ##AltLocation:string##) or (u.Location like ##AltLocation2:string##) ORDER by u.Reputation DESC