Find up to 500 users who are in the same location as you.
Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
-- Find Other SO Users In Your Location -- Find up to 500 users who are in the same location as you. select top 500 u.id as [User Link], u.reputation as [User Rep] from users u where upper(u.location) like upper('%' + ##YourLocation:string## + '%') -- uppercase location