0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select displayName, Reputation, WebsiteUrl, Location, AboutMe from Users 
where (upper(Location) like '%KANSAS%' 
and upper(Location) <> 'KANSAS CITY, MO')
OR upper(Location) like '% KS'
OR upper(Location) like '% KS %' 
OR upper(Location) = 'KS' 
order by Reputation desc

fork query

edited may 23 14

created may 23 14 Nathan Hughes