Users Location ends with X

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find users who's location field contains the specified parameter.

Stack Overflow

Q&A for programmers

-- Users Location LIKE '%XXX%' with Website
-- Find users who's location field contains the specified parameter.
-- Only users with a website will be displayed

SELECT us.DisplayName, 
us.Id as [User Link],
  us.Reputation,
  us.Age,
  
  us.Location
FROM Users us
WHERE Location LIKE '%##Location##%'
ORDER BY us.Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results